Rails 3 regular expression. like in query

Question

I want to query my database table where the age field have a value 24 or 26. I tried using 'like' in my query.

User.where('age like ? or age like ?',"%24%","%26%")

Am I doing something wrong here?

why are you using like when you can direclty check for equality? User.where("age = ? or age = ?", 24, 26) — pahnin, Jun 03 '13 at 07:23
your query should be working, what us the error you are getting ?! — sameera207, Jun 03 '13 at 07:24

Sachin R · Answer 1 · 2013-06-03T07:33:00.920

0

try this

User.where("age in ?",["24","26"])

Let consdier your age in string with comma delimiter

ages = "24,26,28,17,18"
age_array = ages.split(",")
User.where("age in ?",age_array)

edited Jun 03 '13 at 07:33

answered Jun 03 '13 at 07:21

Sachin R

I believe @polurupraveen is looking one with LIKE – sameera207 Jun 03 '13 at 07:26
@sameera207 but he doesnt have to when he is only checking for exact number, right? – pahnin Jun 03 '13 at 07:27
That will match the field values exactly. I want to query using a regular expression because my user age is a string with commas as delimiter – Jun 03 '13 at 07:28
@polurupraveen then you can try converting the string to int – pahnin Jun 03 '13 at 07:29
@JohnnyB-- Ages are comma separated in the database. Not in a variable – Jun 03 '13 at 07:35
@polurupraveen I just give an example ages varaible value can be assigned from database column too. – Sachin R Jun 03 '13 at 07:37
Sorry for the trouble guys. My query was correct except for an extra comma when i tried in my console. My bad. Thanks for helping and sorry again – Jun 03 '13 at 07:41
1

`User.where("age in ?",["24","26"])` will give you syntax error you have to use `User.where("age in (?)",["24","26"])` note for `()` surrounding the `?` – Salil Jun 03 '13 at 07:46
@polurupraveen Please delete the question if it was just a typo. – Substantial Jun 03 '13 at 08:02

score 0 · Answer 2 · answered Jun 03 '13 at 08:16

0

You can try this too ..

User.where(:age => age_array)

answered Jun 03 '13 at 08:16

sushilprj

score 0 · Answer 3 · answered Oct 12 '13 at 20:24

Use this pattern for multiple search attributes:

ages = ["24", "26"]
query = ages.map { |age| "age like '%#{age}%'" }.join(" OR ")
User.where(query)

It will auto generate a query like this:

SELECT 'users.*' FROM 'users' WHERE (age like '%24%' OR age like '%26%')

Hope this solution will help you!

3 Answers3