Skip to content

Instantly share code, notes, and snippets.

@alexbartlow

alexbartlow/gist:800667

Created January 28, 2011 18:08
Show Gist options
  • Save alexbartlow/800667 to your computer and use it in GitHub Desktop.
Save alexbartlow/800667 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.rb
scope :search do |*keywords|
where("FIND_IN_SET(search_column, '#{keywords.join(',')}')")
end
@arfon
Copy link

arfon commented Apr 10, 2012

Does this work? I've been using something like:

  module Scopes
    def search(*keywords)
      where("FIND_IN_SET('#{keywords.join(',')}', search_column)")
    end
  end

  extend Scopes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment