FIND_IN_SET

Syntax

FIND_IN_SET(str,strlist)

Purpose

You can call this function to return the position, starting from 1, of the str string in the strlist string list. If str does not exist in strlist, 0 is returned. If str or strlist is NULL, NULL is returned.

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 (0.00 sec)