[Vince]

Quote:

Originally Posted by BlowUP but with LIKE % i can find ip's starting with 127.0 only example

Since you explicitly mention IPs, consider saving them in integer format because this gives you additional possibilities to search. You can do:

PHP Code:

... WHERE ip BETWEEN INET_ATON('172.16.0.0') AND INET_ATON('172.31.255.255'); 


Which would be shear impossible to accomplish with LIKE. See my tutorial for a more elaborate explanation.