Hi, I have a collection named “members” in wix database with fields/columns as “regno”, “name”, “email” and etc. I want to perform a query on it using “in” clause the way we do in sql. lets say select * from members where regno in (271,272,273) how this can be achieved using wix query? I tried…

"in" clause in wix query

J.D September 13, 2019, 7:02am 5

And if this “rengo” field is indeed of type Text (if it’s number, remove the quotation marks from the query values).

Topic		Replies	Views
Search in several fields in table Ask the community code , question	5	1319	December 31, 2017
Ability to disable parts of a wix-data query Ask the community code	0	79	February 16, 2018
I need to make the query and validate the data.Someone to help me urgently? Ask the community code , question	3	118	December 18, 2018
Select only two of the four columns from Wix Database collection and connect to Table using wix query. Ask the community code , question	4	1966	April 10, 2019
Wix equivalent of the WHERE clause Ask the community code , wix-stores , question	1	216	February 22, 2018