Re: search comma separated db column

[Rick James]

Can I play, too? Call me something other than "troll", that name is taken.

REGEXP, with the word boundary markers:

mysql> select * from commas where a REGEXP '[[:<:]]32[[:>:]]';
+---------+
| a |
+---------+
| 7,32,87 |
+---------+

mysql> select * from commas where a REGEXP '[[:<:]]3[[:>:]]';
+-------------+
| a |
+-------------+
| 1,2,3,23,77 |
+-------------+

mysql> select * from commas where a REGEXP '[[:<:]]7[[:>:]]';
+---------+
| a |
+---------+
| 7,32,87 |
+---------+

http://dev.mysql.com/doc/refman/5.0/en/regexp.html