How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?

by

\ functions as an escape character in LIKE by default.

From the manual for LIKE:

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.

You can change this by specifying another escape character, as in:

SELECT * FROM `titles` WHERE title LIKE 'test\\' ESCAPE '|'

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Using PHP data in MySQL [closed]
  4. Save the data into a database and return another value from database using PHP
  5. Checking the availability of rooms
  6. How can I do ‘insert if not exists’ in MySQL?
  7. Can I parameterize the table name in a prepared statement?
  8. How to properly set up a PDO connection
  9. Getting raw SQL query string from PDO prepared statements
  10. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  11. MySQL Prepared statements with a variable size variable list
  12. Loading .sql files from within PHP
  13. PDO with INSERT INTO through prepared statements [closed]
  14. Escaping single quote in PHP when inserting into MySQL [duplicate]
  15. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  16. Comma separated values in MySQL “IN” clause
  17. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  18. Doing a while / loop to get 10 random results
  19. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  20. How to execute raw queries with Laravel 5.1?
  21. Simple PHP SQL login troubleshooting
  22. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  23. MySql PHP select count of distinct values from comma separated data (tags)
  24. Laravel Eloquent get results grouped by days
  25. Do I have to use mysql_real_escape_string if I bind parameters?
  26. SELECT row by DATEPART()
  27. UNION syntax in Cakephp
  28. How do i search from serialize field in mysql database?
  29. PDO and MySQL ‘between’
  30. MySQL Join Multiple Rows as Columns

Leave a Comment