mysql逗号 regexp,MySql REGEXP匹配两个逗号分隔的字符串

I have a table containing following values :

id | value |

-----------------------

1 | 1,2,5,8,12,20 |

2 | 11,25,26,28 |

-----------------------

now I want to search some comma separated IDs e.g. '1,3,6,7,11' from above value column e.g.

SELECT id FROM tbl_name

WHERE value REGEXP '*some reg exp goes here containing 1,3,6,7,11*'

LIMIT 1,0;

SELECT id FROM tbl_name

WHERE value REGEXP '*some reg exp goes here containing 3,6,27,15*'

LIMIT 1,0;

above 1st query should return 1 while the 2nd should return NULL

I am new with regular expressions can anyone help. Thanks

解决方案REGEXP '(^|,)(1|3|6|7|11)(,|$)'

Will match all values containing one number of the sequence 1,3,6,7,11.

You should not use one column to save several values. Normalize data!

Edited answer