How to escape single quotes in MySQL

by

Put quite simply:

SELECT 'This is Ashok''s Pen.';

So inside the string, replace each single quote with two of them.

Or:

SELECT 'This is Ashok\'s Pen.'

Escape it =)

More Related Contents:

  1. When to use single quotes, double quotes, and backticks in MySQL
  2. How can I output MySQL query results in CSV format?
  3. How to convert a string to date in MySQL?
  4. How to find similar results and sort by similarity?
  5. How do I do a fuzzy match of company names in MYSQL with PHP for auto-complete?
  6. How do you extract a numerical value from a string in a MySQL query?
  7. SQL order string as number
  8. How to remove all non-alpha numeric characters from a string in MySQL?
  9. MySQL – length() vs char_length()
  10. Capitalize first letter. MySQL
  11. Can MySQL replace multiple characters?
  12. How to fix double-encoded UTF8 characters (in an utf-8 table)
  13. MySql – Way to update portion of a string?
  14. mysql: why comparing a ‘string’ to 0 gives true?
  15. MySQL : how to remove double or more spaces from a string?
  16. Strip last two characters of a column in MySQL
  17. MySql Query Replace NULL with Empty String in Select
  18. Last index of a given substring in MySQL
  19. How to create a MySQL hierarchical recursive query?
  20. MySQL Error 1215: Cannot add foreign key constraint
  21. Add Foreign Key to existing table
  22. Auto Generate Database Diagram MySQL [closed]
  23. Error #2002 Can’t connect to local MySQL server through socket ‘/Applications/MAMP/tmp/mysql/mysql.sock’ (2)
  24. How to get the max of two values in MySQL?
  25. how to partition a table by datetime column?
  26. MySQL – Cannot insert NULL value in column, but I have a default value specified?
  27. uninitialized constant MysqlCompat::MysqlRes (using mms2r gem)
  28. Migrating data into Firebase from MySQL
  29. Inventory management with stock options
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment