Check if value exists in comma separated list

Question

I have the following values ​​in my sql column: -

a,b,c,de,f 

I want to check if column b present.

Answer 1

You can use FIND_IN_SET () :

 FIND_IN_SET('b',yourcolumn) > 0 

As an example, which will be used in the request:

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

Answer 2

you can use FIND_IN_SET ()

 FIND_IN_SET('a','a,b,c,d,e'); 

http://www.w3resource.com/mysql/string-functions/mysql-find_in_set-function.php

Answer 3

You can use a similar sentence in a column, for example, if the column name contains these values ​​in the users table, you can use this query

 select * from users where name like "%b%"; 

Answer 4

Try the following:

 select * from users where name like "%,b,%" OR name like "b,%" OR name like "%,b" ;