Mega Code Archive

 

Categories / MySQL Tutorial / String Functions

 

FIND_IN_SET(str,strlist)

This function does not work properly if the first argument contains a comma (',') character. mysql> mysql> SELECT FIND_IN_SET('b','a,b,c,d'); +----------------------------+ | FIND_IN_SET('b','a,b,c,d') | +----------------------------+ |                          2 | +----------------------------+ 1 row in set (0.00 sec)