Re: Confusing backslash issues with LIKE

2007-05-23 Thread Yves Goergen
On 23.05.2007 14:49 CE(S)T, Yves Goergen wrote: > [1] > http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like Never mind. This very page says why it is like it is. It's definitely too hot in here today. :( -- Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]> Visit my

Confusing backslash issues with LIKE

2007-05-23 Thread Yves Goergen
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 '%\\%' | +---