Rails: How to find_by a field containing a certain string

sql ruby-on-rails ruby-on-rails-3 ruby-on-rails-3.1

I think something like this should work:

Topic.where("name like ?", "%apple%")

To accomodate for your edit:

Topic.where("name like ?", "%#{@search}%")

Basic string interpolation, you're using the value of @search inside the string %%, so you @search = "apple" then you end up with %apple%

sql ruby-on-rails ruby-on-rails-3 ruby-on-rails-3.1

With PostgreSQL you can also use match operators:

Topic.where("name ~* ?", @search)

sql ruby-on-rails ruby-on-rails-3 ruby-on-rails-3.1

Looks like in Rails 3 you would want to use the where:

Topic.where("name ILIKE ?", "%apple%")

CodeHunter