Hello, I'm having some trouble with the LIKE operator on MySQL 5.0. Here's my transcript:
mysql> select 'abc\\def'; +---------+ | abc\def | +---------+ | abc\def | +---------+ 1 row in set (0.00 sec) mysql> select 'abc\\def' like '%\\%'; +------------------------+ | 'abc\\def' like '%\\%' | +------------------------+ | 0 | +------------------------+ 1 row in set (0.00 sec) mysql> select 'abc\\def' like '%\\\\%'; +--------------------------+ | 'abc\\def' like '%\\\\%' | +--------------------------+ | 1 | +--------------------------+ 1 row in set (0.00 sec) The last two show my problem. When I search for a backslash, I need to escape it *twice*. Why that? I can't see that from the manual [1]. [1] http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my web laboratory at http://beta.unclassified.de -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
