How to Run a Case Insensitive, Wildcard Search in Rails

ActiveRecord is a great tool for running standard database SQL queries, however there are times where you need a little more flexibility, below is the syntax for running a wild card, case insenstive search in a Rails application: