Mysql Like %..% operator
#3

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%'
Reply


Messages In This Thread
Mysql Like %..% operator - by BlowUP - 05.11.2015, 13:10
Re: Mysql Like %..% operator - by jeffery30162 - 05.11.2015, 13:25
Re: Mysql Like %..% operator - by BlowUP - 05.11.2015, 13:36
Re: Mysql Like %..% operator - by Lordzy - 05.11.2015, 13:36
Re: Mysql Like %..% operator - by BlowUP - 05.11.2015, 13:40
Re: Mysql Like %..% operator - by Vince - 05.11.2015, 15:14

Forum Jump:


Users browsing this thread: 2 Guest(s)