String Types Matter For Complicated ActiveRecord Queries

query.rb

[29] pry(main)> Clinic.where("subdomain LIKE ?", "%\_%")
=> [#<Clinic:0x007f8212b97b98
  id: 1,
  name: "Factory Clinic 1",
  subdomain: "factory-clinic-1",
  privacy_policy: nil,
  optional_data_sharing: false,
  automated_texting: false,
  company_id: 2>,
 #<Clinic:0x007f8212b97a08
  id: 2,
  name: "Factory Clinic 2",
  subdomain: "factory-clinic-2",
  privacy_policy: nil,
  optional_data_sharing: false,
  automated_texting: false,
  company_id: 2>]
[30] pry(main)> Clinic.where("subdomain LIKE ?", '%\_%')
=> []


# Note that the query on L30 has the expected output.