PyMongo - Using variables to sql 'LIKE' queries

Question

The answer here applies when using PyMongo to search fields containing a search text. But only for hard-coded string values:

 db.houses.find({"hid":{"$regex": u"9"}})

So, how to shape that expression replacing that "9" with a variable?

def some_func(search_text)
    db.houses.find({"hid":{"$regex": ??????}})

are you stating that db.houses.find({"hid":{"$regex": search_text}}) won't work? — RomanPerekhrest
– RomanPerekhrest, Commented Jul 18, 2019 at 10:47
The linked answer had comments looking for that kind of implementation. So, this question is for the ones hitting the end of the road on that question. — vahdet
– vahdet, Commented Jul 18, 2019 at 10:58

Umesh Chaudhary · Accepted Answer · 2019-07-21 19:21:20Z

2

Use re module to create a regex for your search string

import re
search_string = re.compile('9')
db.houses.find({'hid': search_string})

you can use a lot of options available in re module

answered Jul 21, 2019 at 19:21

Umesh Chaudhary

4112 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shaik moeed · Accepted Answer · 2019-07-18 10:47:27Z

1

Try this,

search_text = u"9"
db.houses.find({"hid":{"$regex": search_text }})

answered Jul 18, 2019 at 10:47

shaik moeed

5,5882 gold badges25 silver badges63 bronze badges

Ok, my first example confused you. Putting search_text that way is not always possible.

@vahdet From comments provided from linked answer. it's '9' where u'9' should work.