Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Escape Special Characters

By: FYIcenter.com

(Continued from previous topic...)

How To Escape Special Characters in SQL statements?

There are a number of special characters that needs to be escaped (protected), if you want to include them in a character string. Here are some basic character escaping rules:

  • The escape character (\) needs to be escaped as (\\).
  • The single quote (') needs to be escaped as (\') or ('') in single-quote quoted strings.
  • The double quote (") needs to be escaped as (\") or ("") in double-quote quoted strings.
  • The wild card character for a single character (_) needs to be escaped as (\_).
  • The wild card character for multiple characters (%) needs to be escaped as (\%).
  • The tab character needs to be escaped as (\t).
  • The new line character needs to be escaped as (\n).
  • The carriage return character needs to be escaped as (\r).

Here are some examples of how to include special characters:

SELECT 'It''s Sunday!' FROM DUAL;
It's Sunday! 

SELECT 'Allo, C\'est moi.' FROM DUAL;
Allo, C'est moi.

SELECT 'Mon\tTue\tWed\tThu\tFri' FROM DUAL;
   Mon   Tue     Wed     Thu     Fri

(Continued on next topic...)

  1. What Is SQL Standard?
  2. How Many Groups of Data Types?
  3. What Are Character String Data Types?
  4. What Are the Differences between CHAR and NCHAR?
  5. What Are the Differences between CHAR and VARCHAR?
  6. What Are the Differences between BINARY and VARBINARY?
  7. What Are Numeric Data Types?
  8. What Are Date and Time Data Types?
  9. How To Calculate Expressions with SELECT Statements?
  10. How To Include Comments in SQL Statements?
  11. How To Include Character Strings in SQL statements?
  12. How To Escape Special Characters in SQL statements?
  13. How To Concatenate Two Character Strings?
  14. How To Include Numeric Values in SQL statements?
  15. How To Enter Characters as HEX Numbers?
  16. How To Enter Numeric Values as HEX Numbers?
  17. How To Enter Binary Numbers in SQL Statements?
  18. How To Enter Boolean Values in SQL Statements?
  19. What Are NULL Values?
  20. What Happens If NULL Values Are Involved in Expressions?
  21. How To Convert Numeric Values to Character Strings?
  22. How To Convert Character Strings to Numeric Values?
  23. How To Use IN Conditions?
  24. How To Use LIKE Conditions?
  25. How To Use Regular Expression in Pattern Match Conditions?
  26. How To Use CASE Expression?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...