MongoDB query to search for users with best match?

Asked Dec 15 '17 at 10:33

Active Dec 15 '17 at 10:47

Viewed 175 times

I have a users collection which contains documents with name key. I have data of users as follow:

name

halex
alex
galexi
joe alex

I need to apply find() query for alex. My query is:

db.users.find({name:"alex"});

In my result I get the alex at 3rd position.

I want it on 1st position because of the exact match. Example:

alex
halex
joe alex
galexi

edited Dec 15 '17 at 10:47

asked Dec 15 '17 at 10:33

That query should return just two items, what do you mean? – Héctor Dec 15 '17 at 10:37
I want it as mySQL like operator – 720p Download Watch Dabangg 3 Dec 15 '17 at 10:39
Oh I understand. Maybe this helps: https://stackoverflow.com/questions/10610131/checking-if-a-field-contains-a-string – Héctor Dec 15 '17 at 10:40
Yes, but I want my exact match on top and rest below it. – 720p Download Watch Dabangg 3 Dec 15 '17 at 10:43
https://docs.mongodb.com/v3.4/reference/operator/query/text/#return-the-text-search-score – Neodan Dec 15 '17 at 11:04

0 Answers0