How do I do a LIKE % query in ActiveRecord?

Question

I'm trying to find some items that contain a certain string. If I do:

MyModel.where("description LIKE ?",keyword)

it will generate a query for an exact match. I would like to make it generate a LIKE %keyword% query. How can I do that?

Answer 1

like_keyword = "%#{keyword}%"    
MyModel.where("description LIKE ?", like_keyword)

Answer 2

MyModel.where("description LIKE (?)", "%#{keyword}%")