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
?