Text search problem

[Igor]

Hi,

Let's see if this help:
pre
code
{"fieldName":{"$regex":"wor","$options":"im"}}
/code
/pre

This link should be helpful: http://docs.mongodb.org/manual/refere...

[bahar.wadia]

Hello Igor,

This only works for the first word in the sentence. Meaning, in the example I described above it will not return any rows because 'world' is the second word.

Thanks

[Maryna Brodina]

Hello! Try pre{"fieldName": {"$regex": "\\bwor.*", "$options":"im"}}/pre

[bahar.wadia]

That works great. I was missing the extra \ .

I am assuming that since you use Mongodb, which is compatible with PCRE, one can use any PCRE directives. Am I correct in my assumption?

[Maryna Brodina]

Yes, you're right.

[bahar.wadia]

Thank you and slight correction...

when passing a query parameter the correct format is:

{"fieldName": {"$regex": "\\\\bwor.*", "$options":"im"}}

Thanks

[Joe7349603]

Thanks for sharing ended up using your solution...Works great! Cheers!

[Adam Garbinski]

Glad it worked for you Joe! You welcome.