http://www.mysql.net/Manual_chapter/manual_Reference.html#Date_and_time_functions Within a string, certain
http://www.mysql.net/Manual_chapter/manual_Reference.html#Date_and_time_functions
Within a string, certain sequences have special meaning. Each of these sequences begins with a backslash (`’), known as the escape character. MySQL recognizes the following escape sequences:
\0 An ASCII 0 (NUL) character.
\n A newline character.
\t A tab character.
\r A carriage return character.
\b A backspace character.
‘ A single quote (`”) character.
” A double quote (`”‘) character.
\ A backslash (`’) character.
\% A `%’ character. This is used to search for literal instances of `%’ in contexts where `%’ would otherwise be interpreted as a wildcard character.
There are several ways to include quotes within a string:
A `” inside a string quoted with `” may be written as `”’.
A `”‘ inside a string quoted with `”‘ may be written as `”"‘.
You can precede the quote character with an escape character (`’).
A `” inside a string quoted with `”‘ needs no special treatment and need not be doubled or escaped.
