FIND_IN_SET
Learn how to use the FIND_IN_SET string function in PlaidCloud Lakehouse. Returns the position of a string within a comma-separated list.
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 │
└───┘