Re: help in select ... where ...like...

[Rick James]

Or use the word boundary regexp found in
http://dev.mysql.com/doc/refman/5.1/en/regexp.html

mysql> select vc from misc where vc rlike '[[:<:]]4[[:>:]]';
+--------+
| vc     |
+--------+
| 4,2,33 |
+--------+
1 row in set (0.00 sec)

mysql> select vc from misc where vc rlike '[[:<:]]3[[:>:]]';
Empty set (0.00 sec)

mysql> select vc from misc where vc rlike '[[:<:]]2[[:>:]]';
+--------+
| vc     |
+--------+
| 1,2,11 |
| 4,2,33 |
+--------+
2 rows in set (0.00 sec)

mysql> select vc from misc where vc rlike '[[:<:]]1[[:>:]]';
+--------+
| vc     |
+--------+
| 1,2,11 |
+--------+
1 row in set (0.00 sec)

mysql> select vc from misc where vc rlike '[[:<:]]11[[:>:]]';
+--------+
| vc     |
+--------+
| 1,2,11 |
+--------+
1 row in set (0.00 sec)