MySQL FIND_IN_SET() returns the position of a string if it is present (as a substring) within a list of strings.
MySQL FIND_IN_SET(str, strlist) is a string function that returns the index position of the search string str inside the string list strlist. The string list itself is a string containing substrings separated by ‘,’ (comma) character.
This function returns 0 when search string does not exist in the string list and returns NULL if either of the arguments is NULL.
Syntax
FIND_IN_SET(search_string, string_list)
Arguments
- search_string: a string which is to be looked for in following list of arguments.
- string_list: list of strings to be searched if they contain the search string.
Example
The following MySQL statement finds the search string ‘ank’ at 2nd place within the string list. So it returns 2.
Code
SELECT FIND_IN_SET('ank','b,ank,of,monk');
Output
FIND_IN_SET('ank','b,ank,of,monk')
2
