How to find text in mongodb like LIKE in mySQL?

Question

I find text in mongodb as the same LIKE in MySQL, but the result is not as expected

I have 6 docs in collection posts:

(1) David Beckham's Kids Cheer Him on During Charity Soccer Game

(2) David Beckham is casual in sweater and jeans as he attends Copa

(3) David Beckham spoke out in view of his 55.6 million Instagram followers, saying

(4) David Beckham's family were out in force to support him at the

(5) Handsome: David Beckham looked dapper in a shirt and olive-green jacket before another day of shooting for his eyewear collection in Venice

(6) But on Wednesday, David Beckham was spotted going back to his roots as he caught up with Tottenham ace Harry Kane on the football pitch

SQL's like query:

SELECT * FROM posts WHERE content LIKE '%David%Tottenham%'

=> (6) But on Wednesday, David Beckham was spotted going back to his roots as he caught up with Tottenham ace Harry Kane on the football pitch

Mongo's find query:

db.posts.find({"content": /.*David.Tottenham./})

=> error

I expect the output of Mongo's find query is (6), but the actual output is error

Can Anyone Help Me to find query in mongodb? Thank you!

What error? Why do you have a space after Tottenham? Why do you have two ** at the end? — Ian Mercer, May 28 '19 at 14:51
Sorry, i'd just edited the question and attach image. What error is I do not execute the query with mongo. So i don't know what it is. — followconscience, May 28 '19 at 14:56
Use code formatting for your code text rather than using an image. — JohnnyHK, May 28 '19 at 15:00

score 2 · Accepted Answer · answered May 28 '19 at 14:57

2

you can use mongodb $regex operator. I think this query might work for you:

db.posts.find({"content": {$regex: ".*David.*Tottenham .*"}})

answered May 28 '19 at 14:57

Very nice! But it distinguish "David" with "david". I want the result with "David" and "david" is the same. Can you help me? Thank you! – followconscience May 28 '19 at 15:06
1

you can use `i` at the end, which is for case-insensitive, `{"content": {$regex: /.*David.*Tottenham .*/i}}` – Mohammadreza Mirhajianmoghadam May 28 '19 at 15:22

1 Answers1