where_lower

Provide an easy way to use case insensitive where in ActiveRecord.

The above badges are generated by https://shields.io/

gem 'where_lower'

Supports String, Array, Range
Values in Array and Range will be converted to String and then downcase
Other types will not be touched

SomeActiveRecordClass.where_lower(attribute1: 'AbC', attribute2: ['stRing', 123, :symBol], attribute3: ('AA'..'AZ'))

You can pass a nested hash (1 level deep only) for association condition

record.association_records.where_lower(association_table: {association_column: value})

You can also add table name in key if you are using it with association
I don't plan to support any "smart" table guessing though

record.association_records.where_lower('association_table.association_column' => value)

• Matthew Rudy Jacobs (Who wrote the first version of where_lower method)