Substitute of MySQL FIND_IN_SET(str,strlist)

[hanson]

See also this post on workarounds for find_in_set:

Do we have mysql equivalent FIND_IN_SET in singlestore?

You could write a udf like my_find_in_set(k, l) that splits comma-separated list (string) l to an array, then loops through it, looking for l. This approach might also help: singlestore> select json_array_contains_string('["a","b","c"]', "b"); +--------------------------------------------------+ | json_array_contains_string('["a","b","c"]', "b") | +--------------------------------------------------+ | 1 | +---------------------------------------…