Multiple values are frequently kept in one column of a MySQL database as a comma-separated list. Finding a particular value within this list, though, can be difficult.
In MySQL, the FIND_IN_SET function is available which you can use to easily search value in comma-separated values.
It works with both number and string type of list values and it is different with in() function in working.