Hello all! I am looking for a solution to do a SQL query (in SQL Database Connector) that contains a ‘IN’ operator whose input is a parameter that should be a list of text (for example ‘user1@gmail.com’,‘user2@gmail.com’). Basically, the structure of the request is like this: SELECT user_id FROM …

We just found a workaround with Postgres : we use the function regexp_split_to_table to split the big string (parameter $2 below) which include multiple mails separated by a comma ‘,’ and we manage to use this expression within a IN clause like this : WHERE user_app.mail IN (SELECT * FROM regexp_spl…

SQL Connector - 'IN' operator with text list parameter

Need help Plugins

joeyg July 28, 2021, 6:49pm 2

I’ve been able to get SQL statements with “IN” working with MYSQL. Here’s a thread that might be of help: