Syntax
FIND_IN_SET(str,strlist)
Purpose
Returns the position of the specified string str in the string collection strlist, starting from 1. If str does not exist in strlist, it returns 0. If str or strlist is NULL, it returns NULL.
The str string cannot contain commas (,).
Examples
obclient> SELECT FIND_IN_SET('b','a,b,c,d');
+----------------------------+
| FIND_IN_SET('b','a,b,c,d') |
+----------------------------+
| 2 |
+----------------------------+
1 row in set