Substitute of MySQL FIND_IN_SET(str,strlist)

[DOMINIK_W]

Hi
I am looking for substitue of FIND_IN_SET(str,strlist) function

Returns a value in the range of 1 to N if the string str is in the string list strlist consisting of N substrings. A string list is a string composed of substrings separated by , characters. If the first argument is a constant string and the second is a column of type SET, the FIND_IN_SET() function is optimized to use bit arithmetic. Returns 0 if str is not in strlist or if strlist is the empty string. Returns NULL if either argument is NULL . This function does not work properly if the first argument contains a comma (, ) character.

[hanson]

Hi Dominik,

I see you opened several items regarding MySQL-compatible functions. I don’t have time to answer all these right now. If you have a lot of code and don’t want to change your SQL, your best bet would be to implement all these functions in MPSQL or Wasm (if they are scalar functions). E.g. in Wasm you could import a compression library in Rust and probably write compress/uncompress in a few lines of code.

Eric

[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 | +---------------------------------------…