FIND_IN_SET()

The FIND_IN_SET() function returns the position of a string within a list of strings.

Syntax

FIND_IN_SET(string, string_list)

Parameter Values

     string - Required. The string to search for
string_list - Required. The list of string values to be searched (separated by commas)

Return Values

If string is not found in string_list, this function returns 0
If string or string_list is NULL, this function returns NULL
If string_list is an empty string (""), this function returns 0

Example

SELECT FIND_IN_SET("q", "s,q,l");