Rails: How to find_by a field containing a certain string

sql ruby-on-rails ruby-on-rails-3 ruby-on-rails-3.1
varatis picture varatis · Mar 14, 2012 · Viewed 64.2k times · Source

I have a model named Topic, that has a name as a field.

So say I have a term I'm searching for, apple.

If I do a 

Topic.find_by_name("apple")

I get a record back with the name apple. That's good -- but how do I change find_by_name so that it can find "apple juice" as well as "apple" -- basically, find names that contain the original query or exactly match the original query?

Edit: Thanks for all the response. I guess I should've been a little more clear earlier, but what if I want to find by a variable name (obviously I'm not going to want to find by the name "apple" everytime :) )?

How do I manipulate Topic.where to accommodate for this? So something like...

@topic = Topic.where(......., @name)

Answer

Deleteman picture Deleteman · Mar 14, 2012

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%

Related questions

ActiveRecord: List columns in table from console

I know that you can ask ActiveRecord to list tables in console using: ActiveRecord::Base.connection.tables Is there a command that would list the columns in a given table?

Read More
Find all records which have a count of an association greater than zero

I'm trying to do something that I thought it would be simple but it seems not to be. I have a project model that has many vacancies. class Project < ActiveRecord::Base has_many :vacancies, :dependent => :destroy end I …

Read More
Rails joins through association

In Ruby on Rails, I want to find employers in the city. Lets say the models are set up this way: City has_many :suburbs has_many :households, :through => suburbs has_many :people, :through => suburbs Suburb has_many :…

Read More