regexp with mysql
| From: | tony | Date: | Thu, 15 Jan 2004 13:53:09 +0000 |
| Subject: | regexp with mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-174649@lists.php.net to get a copy of this message | ||
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
thank you