Use LIKE/regex with variable in mongoid

Question

I'm trying to find all documents whose text contains the word test. The below works fine:

@tweets = Tweet.any_of({ :text => /.*test.*/ })

However, I want to be able to search for a user supplied string. I thought the below would work but it doesn't:

searchterm = (params[:searchlogparams][:searchterm])
@tweets = Tweet.any_of({ :text => "/.*"+searchterm+".*/" })

I've tried everything I could think of, anyone know what I could do to make this work.

Thanks in advance.

I think you should add "i" at the end there /.*test.*/i to make that work without being case sensitive. — Răzvan Ciocănel, Mar 27 '13 at 08:41

score 31 · Accepted Answer · edited Sep 14 '12 at 02:01

31

searchterm = (params[:searchlogparams][:searchterm])
@tweets = Tweet.any_of({ :text => Regexp.new ("/.*"+searchterm+".*/") })

or

searchterm = (params[:searchlogparams][:searchterm])
@tweets = Tweet.any_of({ :text => /.*#{searchterm}.*/ })

edited Sep 14 '12 at 02:01

Timmy

100
9

answered Dec 15 '11 at 16:43

Nat

3,587
20
22

What I need to do if i want to search like there is location Mumbai and I am passing the location like Mumbai, Maharashtra , India. But it is not searching.. here is my query Event.any_of(location: /.*mumbai maharashtra.*/is).entries. Its not working but if I pass a mumbai then its working. Please suggest. – Mohd Anas Nov 26 '14 at 05:36

score 15 · Answer 2 · edited May 25 '15 at 04:07

15

There is nothing wrong with the mongodb regex query. The problem is passing variable to ruby regex string. You cannot mix string with regex like normal strings

Instead

 "/.*"+searchterm+".*/"

try this

  >>searchterm = "test"
  >>"/#{searchterm}/"
  >> "/test/"

edited May 25 '15 at 04:07

user3631094

3
2

answered Dec 15 '11 at 16:43

RameshVel

64,778
30
169
213

4

Thanks a bunch, Ramesh. I had to remove the " at start and end and then your example worked perfectly. Brilliant! – Hinchy Dec 15 '11 at 16:49

score 1 · Answer 3 · edited Oct 22 '13 at 08:10

1

@tweets = Tweet.any_of({ :text => Regexp.new (".*"+searchterm+".*") })

is ok and have result

edited Oct 22 '13 at 08:10

kleopatra

51,061
28
99
211

answered Oct 22 '13 at 08:04

sitoto

11
1

score 0 · Answer 4 · answered Jul 09 '12 at 00:26

0

This worked for me by doing:

Model.find(:all, :conditions => {:field => /regex/i})

answered Jul 09 '12 at 00:26

methodofaction

70,885
21
151
164

score 0 · Answer 5 · answered May 16 '13 at 06:02

@tweets = Tweet.any_of({ :text => Regexp.new ("/.*"+searchterm+".*/") })

is work, but no result

@tweets = Tweet.any_of({ :text => Regexp.new (".*"+searchterm+".*") })

is ok and have result

@tweets = Tweet.any_of({ :text => /.*#{searchterm}.*/ })

is work, no result

My mongoid version is 3.1.3 and ruby version is 1.9.3

Use LIKE/regex with variable in mongoid

5 Answers5

Linked