How to use LIKE query in Ruby on Rails

Question

LIKE query in mysql, queries the database and disregards case. For example:

"bzupnick" = "Bzupnick" #  false
"bzupnick" LIKE "Bzupnick" # true

So how does one do a LIKE query in Ruby on Rails.

Here's an example query:

@results = User.joins(:jobs).where(:jobs => { :job_name => job }, :users => { :zip => zip })

Aditya Kapoor · Accepted Answer · 2013-04-24 20:11:45Z

10

try this..

User.joins(:job).where("job_name like ? and name like ?","%Dummy%", "%Bzupnick")

You can also verfify the SQL query by putting to_sql at the end of the above statement

answered Apr 24, 2013 at 20:11

Aditya Kapoor

1,57010 silver badges13 bronze badges

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

1 Comment

So the "?"s and "%" thing didn't work, but using interpolation, it worked beautifully.