Syntax
------

FIND_IN_SET(pattern, strlist)

Description
-----------

Returns the index position where the given pattern occurs in a string list.
The first argument is the pattern you want to search for. The second argument
is a string containing comma-separated variables. If the second argument is of
the SET data-type, the function is optimized to use bit arithmetic.

If the pattern does not occur in the string list or if the string list is an
empty string, the function returns 0. If either argument is NULL, the function
returns NULL. The function does not return the correct result if the pattern
contains a comma (",") character.

Examples
--------

SELECT FIND_IN_SET('b','a,b,c,d') AS "Found Results";
+---------------+
| Found Results |
+---------------+
|             2 |
+---------------+

URL: https://mariadb.com/kb/en/find_in_set/