Page 3 of 4
Multiple values for "where" in one database query
Posted: Mon Feb 18, 2013 6:33 am
by Kateryna Grynko
Hi,
To search several field values you can use the following syntax:code{"Maker" : {$in: ["Samsung", "Nokia", "Sony"]} }/code
To search in several fields you should use commas:code{"Maker" : {$in: ["Samsung", "Nokia", "Sony"]}, Model: "Galaxy SIII" }/code
Multiple values for "where" in one database query
Posted: Mon Feb 18, 2013 8:18 am
by Kateryna Grynko
Hello,
We have non-relational database therefore this request is impossible yet.
Multiple values for "where" in one database query
Posted: Wed Feb 20, 2013 4:06 am
by Ryan Rigby
Wow could you answer be anymore useless??
How about a couple suggestions then on how to architect the data in the database
Multiple values for "where" in one database query
Posted: Wed Feb 20, 2013 4:24 am
by maxkatz
Let's try and stay constructive in this forum.
We use MongoDB in the backend, thus a tradition SQL query will not always work. Here is more information on how to do a query with a pointer: http://docs.tiggzi.com/documentation/...
Multiple values for "where" in one database query
Posted: Fri Jan 31, 2014 5:47 pm
by Ignacio Valdés
I try to do it but does not work for me 
http://cl.ly/image/3f00140f1e2F
Multiple values for "where" in one database query
Posted: Sat May 16, 2015 5:00 am
by EJLD
Hi There,
in a DB field named "countryName", I am looking for the country "Zambia" but I don't want to key all of the Zambia word.
I thought it would work with {"countryName":{"$in":["Zam"]}}
but nothing comes out.
I must have mis understood the operator '$in' .
may I ask you for the proper operator is any ?
many thks in advance,
Eric
Multiple values for "where" in one database query
Posted: Sat May 16, 2015 5:17 am
by EJLD
Hi There (again)
forget my question above ... I found the proper operator.
for those who could be interested
{"countryName": { $regex: "Zam" } }
more to find out on
http://docs.mongodb.org/manual/refere...
enjoy your wknd !
Eric
Multiple values for "where" in one database query
Posted: Sat May 16, 2015 5:20 am
by Evgene Karachevtsev
Hello Eric,
Thank you for the update!
Multiple values for "where" in one database query
Posted: Mon Jul 20, 2020 7:48 pm
by Joseph Yeung
\""Nokia\""]}} ' "" ; .. data: encodeURI(JSON.stringify(whereClause))
Multiple values for "where" in one database query
Posted: Mon Jul 20, 2020 7:48 pm
by Joseph Yeung