Hi all! Can anyone tell me how I can filter a result in table with a multiply values specified by users eg select * from users where id in (1,2,3,4,5...) where 1,2,3,4,5 specified by users i cannot use text input because it return string value http://joxi.ru/L214zKgTRe3Egm and i cannot use query…

select * from table_name where {{!textinput1.value}} OR column_name IN ({{ textinput1.value.split(', ') }})

Select from MySQL table with "IN" statement

david-dworsky January 8, 2020, 5:51pm 3

So I would suggest something like this for MySQL:

Topic		Replies	Views
MySQL IN() Clause with array 💬 Queries and Resources mysql	2	9737	August 1, 2023
Passing Multiple Values to Text Input 💬 Queries and Resources snowflake	4	3447	August 2, 2023
Array in where clause IN() 💬 Queries and Resources	3	390	October 28, 2024
Select multiple rows with a string of id seperated by commas 💬 App Building sql , table , component	3	1028	May 2, 2024
Using SQL IN statement within Query Library 💬 Queries and Resources	4	629	September 17, 2024