Cannot retrive values stored with 2 backslashes using Like

Hi,

I am using mysql 4.1.9-pro and stored '\\name' in the name column of test table using insert into test(name,address) values('\\\\name','address');

When I tried to retrive this using select * from test where name like '%\\\\name' empty set is retrived

Butwhen i use '%\\name' and '%\\\\\\name' (6 backslashes) and '%\\\\\\\\name' (8 backslashes) it worked fine. Can anybody help me on this. why it is not retreiving the correct result set when I use 4 backslashes?

Also I have seen this behaviour only in several machines. I suspect this is a character_set issue.

Thanks

Hiran

Hmmm, I'm running Mysql 4.1.12a, and on my machine it works fine. Looking at the MySQL changelogs, some problems with 'LIKE' were fixed in 4.1.11, so you might want to consider upgrading.

Considering 4.1.14 and 5.0 are both out, I might consider doing that too...

It's odd taht when you put too many backslashes it still works.
I agree with Itsacon, it must be a bug...