Does this incur a lot development time please?

Basically, I wish to convert a comma separated string, e.g. @str1="1,2,3,4,5", to an array @arr1 so I can use it in, e.g.

SELECT uid FROM table1 WHERE id IN (@arr1);

Thanks a lot in advance
James

Yes, it does.

But you can use FIND_IN_SET() function instead:

SELECT uid FROM table1 WHERE find_in_set(id, @arr1);

If it takes too much development time. please ignore this request.

Used find_in_set before, it was slow.

Of course, I can store @arr1 in my program and pass it to the second query as a parameter - very quick this way - but need to change code.

I was just wonder if there was a simpler way.

please close this ticket as I could not (even as the reporter).

Maybe time to reopen this? I could really use this function.

SQL Server has a function STRING_SPLIT
Oracle regexp_substr
PostgreSQL string_to_array

STRING_SPLIT in SQL Server is a table-valued function, MariaDB doesn't have table-valued functions yet.
string_to_array returns an array, MariaDB doesn't have arrays yet either.
regexp_substr works, see https://mariadb.com/kb/en/regexp_substr/