[BlowUP]

is there a way of using Like % operator via samp query ?

this is what im talking about

[jeffery30162]

I have no idea what 'LIKE %...%' is. If you could explain what it does maybe I can help

[BlowUP]

http://www.tutorialspoint.com/sql/sql-like-clause.htm
used to compare a value to similar values just like strcmp

pawn Code:

` WHERE `ip` LIKE '127.0.0.1'

but with LIKE % i can find ip's starting with 127.0 only example

pawn Code:

SELECT * FROM `banz` WHERE `ip` LIKE '%127.0%'

[Lordzy]

Yes, you can. Insert % twice like "%%" to format a % symbol. Check "Format Specifiers" - https://sampwiki.blast.hk/wiki/Format

[BlowUP]

Quote:

Originally Posted by Lordzy Yes, you can. Insert % twice like "%%" to format a % symbol. Check "Format Specifiers" - https://sampwiki.blast.hk/wiki/Format

Thanks alot

[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.