Skip to main content
Version: Stable-3.1

find_in_set

Description​

This function returns the position of the first str in strlist (start counting with 1). Strlist is a sting separated by commas. If it does not find any str, it returns 0. When the argument is NULL, the result is NULL.

Syntax​

INT find_in_set(VARCHAR str, VARCHAR strlist)

Examples​

MySQL > select find_in_set("b", "a,b,c");
+---------------------------+
| find_in_set('b', 'a,b,c') |
+---------------------------+
|                         2 |
+---------------------------+

keyword​

FIND_IN_SET,FIND,IN,SET