select field with specific data between commas by regex

Question

I have a table in MySQL with these data in it

I want to get rows with "1" in column row1 by regex. How should I do that?

([^,]1/)

i use this regex but it only return the rows with "1" in first comma

Answer 1

You can use FIND_IN_SET() function of mysql

select * from my_table where FIND_IN_SET('1',row1) > 0