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 ‘[email protected]’,‘[email protected]’). Basically, the structure of the request is like this:
SELECT user_id FROM user_list WHERE user_email IN ($1)
I have tried different formats to input the list of emails (with ', without ', etc.) but nothing has worked so far. Any ideas on how we would solve this?
@phuthi, I saw in one of your post dating back to 2017 that you were facing the same challenge at the time. Have you found a way to make it work since then?
Below a screenshot of the exact request that we are trying to make.
Thanks a lot!!