Page 1 of 1

Case Insensitive DB Query

Posted: Tue Feb 11, 2014 4:28 pm
by Christopher Herold

I am trying to create a query that is case insensitive.

My original query is

"where": '{"username":"' + username + '"}'

How do I make this case insensitive??

I tried

"where": '{"username":{ $regex: /+ username +/i } }'

with no success.


Case Insensitive DB Query

Posted: Tue Feb 11, 2014 5:09 pm
by Kateryna Grynko

Hi Christopher,

Parameter 'where' should have this format:pre{"username":{"$regex":"username", "$options":"i"}}/pre
Find more here: https://getsatisfaction.com/apperyio/...