To include a quote character within a string that is quoted by the same kind of quote, : Char « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Char

To include a quote character within a string that is quoted by the same kind of quote,

      
mysql>
mysql> SELECT 'I''m asleep', 'I\'m wide awake';
+------------+----------------+
| I'm asleep | I'm wide awake |
+------------+----------------+
| I'm asleep | I'm wide awake |
+------------+----------------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT "He said, ""Boo!""", "And I said, \"Yikes!\"";
+-----------------+----------------------+
| He said, "Boo!" | And I said, "Yikes!" |
+-----------------+----------------------+
| He said, "Boo!" | And I said, "Yikes!" |
+-----------------+----------------------+
1 row in set (0.00 sec)








Related examples in the same category

1.CHAR(n): character string with specified length
2.Quoting a string value
3.The CHAR data type is a fixed-length character data type that can store up to 255 characters.
4.Add zero to the values to force a string-to-number conversion
5.Writing Strings That Include Quotes or Special Characters
6.Testing String Equality or Relative Ordering
7.To find out whether a string lies within a given range of values (inclusive)
8.If you are comparing strings and numerics, or floating-point numbers and integers, MySQL will compare them as
9.Not equal char type value
10.Max with char type values
11.Compare char type value
12.Not null char type column