From: Dan Nelson
Date: February 11 2002 7:02pm
Subject: Re: Problem wish slashes & LIKE query
List-Archive: http://lists.mysql.com/mysql/99160
Message-Id: <20020211190203.GV44170@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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