MongoDB Database, query with LIKE

Question

I have a MongoDB, I can query the database with 'Country' that works fine. But I now want to also search on the field 'title' with free text. As with in SQL the WHERE title LIKE '%title%'

BasicDBObject query = new BasicDBObject();
query.put("country", country);
query.put("title", %title%);
DBCursor cursor = collection.find(query);

How would I do this with MongoDB?

Duplicate of http://stackoverflow.com/questions/3305561/how-to-query-mongodb-with-like — Grzegorz Rożniecki, Aug 23 '11 at 07:53
How would I put this into my code? BasicDBObject query = new BasicDBObject(); query.put("country", country); query.put("title", /title/i); ??????????? — Marc Stevens, Aug 23 '11 at 09:04
Possible duplicate of [How to query MongoDB with "like"?](https://stackoverflow.com/questions/3305561/how-to-query-mongodb-with-like) — Dan Is Fiddling By Firelight, Mar 30 '19 at 15:28

score 4 · Answer 1 · answered Aug 23 '11 at 07:52

4

You can use regular expressions In your case, /title/i should work (as MySQL like query is usually case-insensitive, /i denotes case-insensitive match)

answered Aug 23 '11 at 07:52

Maxim Krizhanovsky

26,265
5
59
89

Thanks! How would I put this into my code? BasicDBObject query = new BasicDBObject(); query.put("country", country); query.put("title", /title/i); ??????????? – Marc Stevens Aug 23 '11 at 08:08

score 0 · Answer 2 · answered Jun 01 '12 at 07:22

0

Use this this pattern is java regular expression

Pattern title = Pattern.compile("title");
BasicDBObject dbc=new BasicDBObject();
dbc.put("title", title );
DBCursor cursor = collection.find(query);

This will work,.. try it

answered Jun 01 '12 at 07:22

Sadesh Kumar N

1,962
7
19
26

score 0 · Answer 3 · answered Dec 27 '13 at 01:56

if you got the keyword in variable...

Model.find( { FIELD_NAME : { $regex: KEYWORD, $options: 'i' }});

and if you got the keyword as just a string...

Model.find( { FIELD_NAME : /string/i });

should work like SELECT * FROM Model WHERE FIELD_NAME LIST = KEYWORD.

'i' toggles case-insensivity, so that you can search the word with no case exception.

MongoDB Database, query with LIKE

3 Answers3