Mongoid: Querying for documents for certain fields which contains a given string

Question

I am a little stuck here (mongoid docs does not seem to give an answer)

Question.where(:text.contains=>"perfect")

I would like to find questions which text field contains a given word, in this case, perfect.

What is the correct query here, and how can i improve the performance of such queries?

Answer 1

You should be able to use simple regex for that:

Question.where(:text => /perfect/)

Alex