Like in MongoDB Query


If you are familiar with SQL Server or another relation database, the  'LIKE' query look like as below.

SELECT * FROM [dbo.][USERS] WHERE FNAME LIKE '%DILIP%'

In MongoDB, it looks like as below(query in MongoDB console)

db.USERS.find({"FNAME":/DILIP/})

Same as

db.USERS.find({"FNAME":/^DILIP/})   // FNAME LIKE 'DILIP%'

db.USERS.find({"FNAME":/DILIP$/})   // FNAME LIKE '%DILIP'

$regex in MongoDB

No comments:

Post a Comment

Please do not enter any spam link in the comment box.

Related Posts

Fatal Error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails.

Problem: Sometimes, we get the following error when trying to make a connection in Rails.  FATAL ERROR: Peer authentication failed for us...