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	1196	August 3, 2023
Select from MySQL table with "IN" statement 💬 Queries and Resources sql	7	1873	August 2, 2023
How to add comma separated values from text component to query's "IN" 💬 Queries and Resources sql	2	3316	August 2, 2023
Using SQL IN statement within Query Library 💬 Queries and Resources	4	814	September 17, 2024
MySQL IN() Clause with array 💬 Queries and Resources mysql	2	10334	August 1, 2023

Select multiple rows with a string of id seperated by commas

Related topics