List:General Discussion« Previous MessageNext Message »
From:Ilia A. Date:February 11 2002 7:03pm
Subject:Problem wish slashes & LIKE query
View as plain text  
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)

mysql> SELECT * FROM test WHERE name='\"///\\o/\\\\\\\'';
+-------------+
| name        |
+-------------+
| "///\o/\\\' |
+-------------+
1 row in set (0.00 sec)


Thanks,

ilia
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