Where clause in Select

hi All,
Could anyone let me know if i can specify a range of ip addresses in the where clause of a select query
Like can i use something like this:

"select * from my_table where ip != '192.168.0.0-255' ";

Here ip is a varchar field and i need to exclude all the ip addresses in the range '192.168.0.0-255'

Regards
Roopa

Where ip not like "192.168.0.%"

you could if you put all the ip in to seperate fields.

$ip1=192
$ip2=0
$ip3=0
$ip4=10

if you did this you could write an sql like this

SELECT * FROM $table WHERE $ip1='192' AND $ip2='0' AND $ip3='0' AND ($ip4 >='0' AND $ip4 <=255);

This would give you what you need.

or you can convert ip to integer (removing dots and adding zeros) and then
WHERE ip >= 192168000000 and ip <= 192168000255

naughty mode:

or port to postgresql and store the IP in the IP datatype:

WHERE IP << '192.168.0.0/24';

Originally posted by vincente
naughty mode:

or port to postgresql and store the IP in the IP datatype:

WHERE IP << '192.168.0.0/24';

This is one of those times that postgresql's extensible data types are really quite compelling.

I recommend it for this kind of thing as well.