Select statement display all ip-addresses of a subnet

[Florian Schilling]

Hi,

I'm not new in Mysql, but my knowledge is just some basics of SQL. I hope somebody could help, because first I'm not sure if it is possible what I'm looking for and further, what do I need to look for :S

Here my question:
I have a table called network_addr which consist of the fields:
- id_network, network_addr, mask

As network_addr is stored in decimal format and mask in number of bits, I can calulate how ip-addresses this network could contain.

Now the question is, is it possible by an sql statement to print a table with all possible ip-addresse?

Hope somebody could help me.

Thanks!