Re: regexp with mysql

> i hope someone can help it should be easy but i still don't get it. > > i have a field which has numbers seperated via a comma > for example 1,2,3,12,14,23,51 > > now if i was to do a search for a the rows that has '2' in it i do > SELECT * FROM table WHERE ids REGEXP "2" > > will it show fields that has 12 22 23 etc...?? or just 2 Yes. I think you need something like: $sql = "SELECT * FROM table WHERE ". "ids REGEXP '2' AND ids NOT REGEXP '([1-9]2)|(2[0-9])'"; But I don't profess to much knowledge of regular expressions. Check the MySQL documentation. I saw something about REGEXP there recently. Also, there's a MySQL discussion list at <http://lists.mysql.com/>. HTH -- Lowell Allen