sanitize_sql_like.rb

class InterfaceCleaner
  include ActiveRecord::Sanitization

  ESCAPE_CHAR = '\\'

  def self.nic_pattern_to_like(nic)
    sanitize_sql_like(nic, ESCAPE_CHAR).tr('*', '%')
  end

  def self.ignored_interface_like_patterns
    Setting[:ignored_interface_identifiers].map { |pattern| nic_pattern_to_like(pattern) }
  end
end