mamdouh asked this 4 years ago

MongoDB how to search for a string or pattern in a field?

How do I search for a string inside a field in MongoDB? In SQL if i want to search name column for a string pizza

SELECT * FROM restaurants WHERE name LIKE '%pizza%';

What is the equivalent of this in MongoDB?

Best Answer by go_mongo 3 years ago

For a case-insensitive search,

db.restaurants.find( { name: /pizza/i } )
go_mongo 3 years ago
1 like

MongoDB equivalent would be

db.restaurants.find({"name": /pizza/})
Binoy 3 years ago

db.restaurants.find( { name: /pizza/ } )