SQLite3 ActiveRecord REGEXP
This adds REGEXP support to SQLite3 in ActiveRecord.
Add this line to your application's Gemfile:
And then execute:
Or install it yourself as:
$ gem install sqlite3_ar_regexp
# find all accounts where the first name starts with "a" Account.where('first_name REGEXP "^a"')
The original code for this was done by Joe Yates and can be found at http://titusd.co.uk/2010/01/31/regular-expressions-in-sqlite/.