Bug #55449 | multi-backslashes in "LIKE" clause not work and WHERE... LIKE is case-sensitive | ||
---|---|---|---|
Submitted: | 21 Jul 2010 16:40 | Modified: | 21 Jul 2010 20:59 |
Reporter: | Zhangling Ren | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
Version: | 5.0.86-enterprise-nt | OS: | Windows (2008) |
Assigned to: | CPU Architecture: | Any | |
Tags: | LIKE clause, UPDATE |
[21 Jul 2010 16:40]
Zhangling Ren
[21 Jul 2010 20:59]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Please read at http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like starting from: Note 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.
[28 Jul 2010 1:27]
MySQL Verification Team
Duplicate of bug #39808