List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:February 11 2002 7:02pm
Subject:Re: Problem wish slashes & LIKE query
View as plain text  
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
Thread
Problem wish slashes & LIKE queryIlia A.11 Feb
  • Re: Problem wish slashes & LIKE queryDan Nelson11 Feb
Re: Problem wish slashes & LIKE queryDan Nelson12 Feb