FIND_IN_SET (Lakehouse v2)
Returns the position of a string within a comma-separated list.
Analyze Syntax
Section titled “Analyze Syntax”func.find_in_set(<str>, <strlist>)Analyze Examples
Section titled “Analyze Examples”func.find_in_set('b', 'a,b,c')
┌───┐│ 2 │└───┘SQL Syntax
Section titled “SQL Syntax”FIND_IN_SET(<str>, <strlist>)SQL Examples
Section titled “SQL Examples”SELECT FIND_IN_SET('b', 'a,b,c');
┌───┐│ 2 │└───┘