Hey there! I have been looking around for an answer for a while but i'm out of luck. Basically what I'm trying to do is to select all items in TABLE1 with ID IN = LINKID, LINKID is a dynamic string of arrays in TABLE2 and looks like this: 1,2,3,.. So this is the code i want to work: SELECT * FROM…

Hi Isack Instead of: SELECT * FROM itemorders WHERE ID IN ( {{listCollection4.selectedItem.linkid}} ); Try: SELECT * FROM itemorders WHERE ID = ANY( {{listCollection4.selectedItem.linkid}} );

Select multiple rows with a string of id seperated by commas

💬 App Building

Paulo April 1, 2024, 11:59pm 3

Hi @Isack98, welcome to the forum!

I recommend going through this SQL Cheatsheet.

1 Like

Topic		Replies	Views
Using selected rows in a table as constrain in a SQL where clause 💬 App Building	5	1137	August 3, 2023
Select from MySQL table with "IN" statement 💬 Queries and Resources sql	7	1807	August 2, 2023
How to add comma separated values from text component to query's "IN" 💬 Queries and Resources sql	2	3233	August 2, 2023
Passing an list of values to an IN clause in MySQL 💬 App Building javascript , sql , mysql	1	7687	June 8, 2023
Using SQL IN statement within Query Library 💬 Queries and Resources	4	508	September 17, 2024

Select multiple rows with a string of id seperated by commas

Related topics