FIND_IN_SET

Returns the position of a string within a comma-separated list.

Analyze Syntax

func.find_in_set(<str>, <strlist>)

Analyze Examples

func.find_in_set('b', 'a,b,c')

┌───┐
 2  
└───┘

SQL Syntax

FIND_IN_SET(<str>, <strlist>)

SQL Examples

SELECT FIND_IN_SET('b', 'a,b,c');

┌───┐
 2  
└───┘