How to handle a query with special characters / (forward slash) and \ (backslash)

by

The trick is to double escape ONLY the backslash; for string escapes only a single escape is needed.

For example

  • The single quote ' only needs escaping once LIKE '%\'%'
  • But to query backslash \ you need to double escape to LIKE '%\\\\%'
  • If you wanted to query backslash+singlequote \' then LIKE '%\\\\\'%' (with 5 backslashes)

Explanation Source
excerpt:

Because MySQL uses C escape syntax in strings (for example, “\n” to
represent a newline character), you must double any “\” that you use
in LIKE strings. For example, to search for “\n”, specify it as “\n”.
To search for “\”, specify it as “\\”; this is because the
backslashes are stripped once by the parser and again when the pattern
match is made, leaving a single backslash to be matched against.

More Related Contents:

  1. Write the function using plsql [closed]
  2. What does it mean by select 1 from table?
  3. Out of memory Microsoft VBScript runtime error 800a0007
  4. Left Outer Join doesn’t return all rows from my left table?
  5. Are table names in MySQL case sensitive?
  6. 1114 (HY000): The table is full
  7. Get table names using SELECT statement in MySQL
  8. UPDATE multiple tables in MySQL using LEFT JOIN
  9. Can a foreign key reference a non-unique index?
  10. How to raise an error within a MySQL function
  11. What is maximum query size for mysql?
  12. Storing Data in MySQL as JSON
  13. Finding all parents in mysql table with single query (Recursive Query)
  14. How do I retrieve my MySQL username and password?
  15. How does a MYSQL Self-Join Work?
  16. How to change the default port of mysql from 3306 to 3360
  17. Is it possible to reference one column as multiple foreign keys?
  18. How to Import Multiple csv files into a MySQL Database
  19. MySQL error #2014 – Commands out of sync; you can’t run this command now
  20. How can we find gaps in sequential numbering in MySQL?
  21. Row to column transformation in MySQL
  22. Find date range overlaps within the same table, for specific user MySQL
  23. How to reuse auto_increment values? [duplicate]
  24. MySQL DROP all tables, ignoring foreign keys
  25. MySQL: Check if the user exists and drop it
  26. Get the second highest value in a MySQL table
  27. Retrieving only a fixed number of rows in MySQL
  28. MySQL Closure Table hierarchical database – How to pull information out in the correct order
  29. Fetching a Single Row from Join Table
  30. mysql double-quoted table names

Leave a Comment