Details
-
Improvement
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
find_in_set(str,str_array) - Returns the first occurrence of str in str_array where str_array is a comma-delimited string.
Returns null if either argument is null. Returns 0 if the first argument has any commas.
Example:
"select find_in_set('cr','crt,c,cr,c,def') as col1 "
-> result: 3