DEV Community

Theo
Theo

Posted on

MongoDB equivalent of SQL LIKE query

#mongodb #sql #regex

A quick snippet for anyone looking for equivalent SQL LIKE queries for mongodb.

db.users.find({name: /a/}) 
SELECT * FROM USERS WHERE name LIKE '%a%';

db.users.find({name: /^ja/}) 
SELECT * FROM USERS WHERE name LIKE 'ja%'

db.users.find({name: /jo$/}) 
SELECT * FROM USERS WHERE name LIKE '%jo'
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Read next

mrcaption49 profile image

MERGE IN SQL

Pranav Bakare -

zaratedev profile image

How to create a read-only user in PostgreSQL

Jonathan Zarate -

mrcaption49 profile image

Parsing in Oracle SQL | Hard parsing | soft parsing.

Pranav Bakare -

techbelle profile image

Supercharging Time Series Collections: Key Enhancements in MongoDB 8.0 with Block Processing

rachelle palmer -