Check if value exists in a comma separated list [duplicate]

Question

I have following values in my sql column:-

Click to copy

a,b,c,d e,f

I want to check if b is present in the column.

Answer 1

You can use FIND_IN_SET():

Click to copy

FIND_IN_SET('b',yourcolumn) > 0

As an example to be used in a query:

Click to copy

SELECT * FROM yourtable WHERE FIND_IN_SET('b',yourcolumn) > 0;