How to escape literal percent sign when NO_BACKSLASH_ESCAPES option is enabled?

by

you need escape

select * from mytable
where mycol like '5\% off' escape '\';

For a version that works regardless of NO_BACKSLASH_ESCAPES mode, you can use a different character, like pipe:

select * from mytable
where mycol like '5|% off' escape '|';

More Related Contents:

  1. How do I escape reserved words used as column names? MySQL/Create Table
  2. How to escape apostrophe (‘) in MySql?
  3. What characters have to be escaped to prevent (My)SQL injections?
  4. How to escape apostrophe (a single quote) in MySql?
  5. How to allow fulltext searching with hyphens in the search query
  6. How to use IN & NOT IN same query [closed]
  7. SQL Print the name of all Employees together with the name of their supervisor
  8. Syntax error due to using a reserved word as a table or column name in MySQL
  9. Change MySQL default character set to UTF-8 in my.cnf?
  10. MySQL: Large VARCHAR vs. TEXT?
  11. MySQL offset infinite rows
  12. Multiple-column foreign key in MySQL?
  13. What is the question mark’s significance in MySQL at “WHERE column = ?”?
  14. How do write IF ELSE statement in a MySQL query
  15. mysql – making a mechanism similar to Oracle’s seqences
  16. Setting up foreign keys in phpMyAdmin?
  17. How to get an age from a D.O.B field in MySQL?
  18. Invalid default value for ‘dateAdded’
  19. Importing a CSV to MySQL with different date format
  20. MySQL: When is Flush Privileges in MySQL really needed?
  21. MySQL too long varchar truncation/error setting
  22. MySQL: update a field only if condition is met
  23. how to use DISTINCT ON with mysql using ActiveRecord
  24. use a variable for table name in mysql sproc
  25. How to create dummy variable columns for thousands of categories in Google BigQuery?
  26. Most efficient way to store IP Address in MySQL [duplicate]
  27. What is the best way to do incremental backups in MySQL?
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment