Mongo Search query by word starting letters

Question

I am worked on my current project with MONGO, I need a query if i am search a letter need to search every word

ex: I have 3 topics named in my db as below

chemistry, chemical, organic chemistry

i tried with query like below

db.topics.find({name: { '$regex': '^che', '$options': 'i' }}, {})

but i am getting results of chemistry and chemical only

but my requirement is if i search with che then that letter need to check firtst letters of every word and results comes with chemistry, chemical and organic chemistry also (because in organic chemistry have word starts with chemistry

Nozar Safari · Accepted Answer · 2018-03-06T06:40:39.767

6

db.topics.find({name: { '$regex': 'che', '$options': 'i' }}, {})

^ in regex means "start" ^che are text with start with che

and if u want che was first in any word u must match spaces:

db.topics.find({name: { '$regex': '(\s+che|^che)', '$options': 'i' }}, {})

for better understand regex check this : https://www.regextester.com/

edited Mar 06 '18 at 06:40

answered Mar 06 '18 at 06:30

Nozar Safari

505
4
17

It does not works or me "\s" is unrecognized can you please help me – Srinivasan Selvaraj Jan 08 '19 at 10:02
what is your problem ? `\s` mean space. `\s+` mean one or many spaces – Nozar Safari Jan 12 '19 at 11:25

score 1 · Answer 2 · answered Feb 05 '19 at 07:45

1

To search letters throw every word, you need to do something like
db.topics.find({name: '/che/'})
For more detailed answer, please check this link

answered Feb 05 '19 at 07:45

chavy

841
10
20

Mongo Search query by word starting letters

2 Answers2