Mongo query using "like" : GameSparks

U

Ufuk Coban

started a topic over 6 years ago

How can i use "like" in nosql windows? i used examples in the link belove. it does not work. i get json syntax error. i tried {log: { $regex: /rebuild/ } } and {log: /rebuild/ }

https://chartio.com/resources/tutorials/how-to-use-a-sql-like-statement-in-mongodb

Best Answer

C

Customer Support said almost 6 years ago

Hi all,

Just a quick amendment to Padraigs answer as it will not work in the new portal due to a more strict parser.

The quotations around $regex should in fact be double quotes rather than single. Like so :

{"log": {"$regex": "rebuild"}}

Best Regards, Patrick.

Customer Support

said over 6 years ago

Hi Ufuk,

For a query like this in the NoSQL Explorer, try this:

{"log": {'$regex': "rebuild"}}

Let me know if this works for you.

-Pádraig

Customer Support

said almost 6 years ago

Answer

Hi all,

Just a quick amendment to Padraigs answer as it will not work in the new portal due to a more strict parser.

The quotations around $regex should in fact be double quotes rather than single. Like so :

{"log": {"$regex": "rebuild"}}

Best Regards, Patrick.

W

Walt Collins

said almost 6 years ago

In my recent testing in the NoSQL explorer, the above answer failed. The solution is to use double quotes instead of single quotes around the word "$regex". So, a working example would be:

{"log": {"$regex": "rebuild"}}

How can we help you today?