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

githaiga22 profile image

🚀 Go-ing Full-Stack: Building Dynamic Web Apps with Go 🐹, PostgreSQL 🐘, Docker 🐳, and HTTP Servers 🌐

Allan Githaiga -

adityabhuyan profile image

Understanding Batch SQL Injection: A Real-World Threat to Data Security

Aditya Pratap Bhuyan -

adityabhuyan profile image

Connecting SQL Databases to the Cloud: PostgreSQL, MySQL, SQLite, and Cloud Integration Explained

Aditya Pratap Bhuyan -

giulianaolmos profile image

Technical Interview Questions - Part 4 - Git + SQL vs noSQL

Giuliana Olmos -