Like independent across mysql and postgres example

cross sql like scope

scope :with_name, lambda { |name|
  case self.configurations[Rails.env]['adapter']
  when 'mysql'
    where("name LIKE '%#{name}%'")
  when 'postgresql'
    where("lower(name) LIKE '%#{name.downcase}%'")
  end
}