Skip to main content

FIND_IN_SET

Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings. A string list is a string composed of substrings separated by , characters. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL. This function does not work properly if the first argument contains a comma (,) character.

Syntax​

FIND_IN_SET(str,strlist)

Arguments​

ArgumentsDescription
strThe string.
strlistThe string.

Return Type​

A number data type value.

Examples​

SELECT FIND_IN_SET('b','a,b,c,d');
+-----------------------------+
| FIND_IN_SET('b', 'a,b,c,d') |
+-----------------------------+
|                           2 |
+-----------------------------+