Mysql FIND_IN_SET() FUNCTION

FIND_IN_SET() : This function is used where you have comma separated list of values stored in database and want to see if a certain value exists in that comma seperated list.

Example: select * from members WHERE FIND_IN_SET( 'HARI', namelist )