Rails 4 LIKE query – ActiveRecord adds quotes

by

Your placeholder is replaced by a string and you’re not handling it right.

Replace

"name LIKE '%?%' OR postal_code LIKE '%?%'", search, search

with

"name LIKE ? OR postal_code LIKE ?", "%#{search}%", "%#{search}%"

More Related Contents:

  1. ActiveRecord Arel OR condition
  2. PostgreSQL where all in array
  3. How to use ANY instead of IN in a WHERE clause?
  4. PostgreSQL GROUP BY different from MySQL?
  5. Best way to count rows by arbitrary time intervals
  6. How to handle Ruby on Rails error: “Please install the postgresql adapter: `gem install activerecord-postgresql-adapter'”
  7. Perform this hours of operation query in PostgreSQL
  8. How to round an average to 2 decimal places in PostgreSQL?
  9. Join multiple tables with active records
  10. SQL where joined set must contain all values but may contain more
  11. Find records where join doesn’t exist
  12. Find all records which have a count of an association greater than zero
  13. Rails find record with zero has_many records associated [duplicate]
  14. Prepared Statement on Postgresql in Rails
  15. Store the day of the week and time?
  16. ActiveRecord find_each combined with limit and order
  17. Grouped LIMIT in PostgreSQL: show the first N rows for each group?
  18. Optimize query with OFFSET on large table
  19. How to concatenate columns in a Postgres SELECT?
  20. How to use (install) dblink in PostgreSQL?
  21. ActiveRecord.find(array_of_ids), preserving order
  22. PostgreSQL multi INSERT…RETURNING with multiple columns
  23. Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL
  24. Oracle equivalent of Postgres’ DISTINCT ON?
  25. Creating a PostgreSQL sequence to a field (which is not the ID of the record)
  26. Grant privileges for a particular database in PostgreSQL
  27. Functions with variable number of input parameters
  28. Converting an array of objects to ActiveRecord::Relation
  29. Check if NULL exists in Postgres array
  30. PGError: ERROR: aggregates not allowed in WHERE clause on a AR query of an object and its has_many objects

Leave a Comment