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
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
