How can I use% in argument: conditions for ActiveRecord.find?

Question

I am trying to make a query like this:

Widget.find(:all, :conditions => ["name like %awesome%"])

However, I get an “irregular string form” exception from sanitize_sql, indicating “%” as the problem.

How to fulfill this request?

Answer 1

Try this syntax:

term = "awesome"
Widget.all(:conditions => ["name LIKE ?", "%#{term}%"])

Answer 2

Try

Widget.find(:all, :conditions => ["name like '%awesome%'"])

Just added single quotes around the string %awesome%

Edit: Well, that really doesn't work. Sql sanitizer does something sluggish with% s.

This will work.

Widget.find(:all, :conditions => ["name like ?","%awesome%"])

According to John Topley's answer, you can make a string a variable if that is what you really need.

, SQL, development.log -, , . , SQL, , , ActiveRecord ( , barfing , )

Answer 3

Your solution does not work because you do not have quotes around% awesome%.