In MongoDB we have indexed text search, so the search don’t have to loop over all records
Query Example:
db.<collection>.find({ $text: { $search: "findThisWord" } })
- MongoDB searches the “findThisWord” in all text indexed fields, which makes this query really efficient
I wonder if MySQL or PostgreSQL has similar features?