如何在mySQL中的数据库表中搜索逗号分隔的字符串

Question

How to search for a comma-separated string in a database table in mySQL.

Suppose, I have a string in variable $facilities='breakfast,dinner,lunch' and in my database I have a string saved in a field called facilities having values breakfast,dinner,clothing,lunch,hot water.

How do I get the row having values $facilities?

Answer 1

Work like this i hope this is your requirement

select * from table where field_name like '%$fieldname%'