Build Status Code Climate Dependency Status Gem Version

activerecord-like on Github

An Active Record Plugin that allows chaining a more DSL-style 'like' or 'not-like' query to an ActiveRecord::Base#where. Requires Rails 5 or higher.

This plugin has been salvaged from the stellar work done by @amatsuda and @claudiob, updated to ActiveRecord 5 by @PikachuEXE and 5.2 by @robotdana and then to ActiveRecord 6.1 by @nrw505. Most of the code was previously in Active Record master, but was subsequently removed due to, amongst other, scope creep (see discussion here). Array parameter handling was added by @rzane - thanks!


Add this line to your application's Gemfile:

gem 'activerecord-like'

And then execute:

$ bundle

Or install it yourself as:

$ gem install activerecord-like


Given a class Post and the WhereChain work in Active Record, this plugin allows code like: "%rails%") ["%ruby%", "%rails%"])


Post.where.not_like(title: "%rails%")
Post.where.not_like(title: ["%ruby%", "%rails%"])


ActiveRecord 5 or higher


  1. Fork it
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Make sure the tests run. I will not merge commits that change code without testing the new code. Running the tests is as easy as running bundle && rake - if this does not work, consider it a bug and report it. Testing with a specific database engine is done using export DB={engine}; bundle && rake or the equivalent for your system. Supported engines are mysql, sqlite3 and pg.
  5. Push to the branch (git push origin my-new-feature)
  6. Create new Pull Request