MySQL: search for a value in a comma separated column

SELECT * FROM `table` WHERE FIND_IN_SET(‘value’, field)

Pulls out everything tagged with value. Field being the column containing comma separated values.