Hello.
> Let's say I wanted to select all rows where column x has a value of ~y Please, could you explain, what does it mean x ~ y. LIKE works for integer, at least in traditional way: mysql> create table tint(a int); Query OK, 0 rows affected (0.04 sec) mysql> insert into tint set a='1113344'; Query OK, 1 row affected (0.02 sec) mysql> insert into tint set a='989345'; Query OK, 1 row affected (0.00 sec) mysql> select a from tint where a like '111%'; +---------+ | a | +---------+ | 1113344 | +---------+ Andy Pieters wrote: > Hi all > > Is there any operator for mysql that behaves like "LIKE" but can act on > numbers. > > Let's say I wanted to select all rows where column x has a value of ~ y > > How should I do this? > > > With kind regards > > > Andy > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]