FIND_IN_SET

Returns the position of a string within a list of strings.

Syntax

FIND_IN_SET(string, string_list)

Example

SELECT FIND_IN_SET(‘a’, ‘b,a,c’);

The above query returns 2.