In the last episode (Feb 11), Ilia A. said:
> I think this may be a problem with MySQL and if it is not please tell me how
> to resolve it.
>
> mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
>
> mysql> CREATE TABLE test( name char(255) NOT NULL, INDEX(name));
> Query OK, 0 rows affected (0.01 sec)
>
> mysql> INSERT INTO test VALUES('\"///\\o/\\\\\\\'');
> Query OK, 1 row affected (0.03 sec)
>
> mysql> select * from test;
> +-------------+
> | name |
> +-------------+
> | "///\o/\\\' |
> +-------------+
> 1 row in set (0.00 sec)
>
> mysql> SELECT * FROM test WHERE name LIKE '\"///\\o/\\\\\\\'';
> Empty set (0.00 sec)
LIKE is parsed one more time, so you can escape % and _. You'll have
to escape all those '\'s one more time, or set a different escape
character in LIKE. See the manual, under String Comparison Functions.
http://www.mysql.com/doc/S/t/String_comparison_functions.html--
Dan Nelson
dnelson@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.