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

---------------------------------------------------------------------
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 <mysql-thread99159@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-cyon=bestweb.net@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
Problem wish slashes & LIKE queryIlia A.12 Feb