> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
