Bug #412 Queries with escape character "\\%" don't retrieve correct results

Description:
A query like this don't return the result expected:

select * from x1 where xName like '\\%'; 

How to repeat:
create table x1 (xName varchar(100));
  insert into x1 values('\\\\aa-xxxx-yy');
    -- this inserts data:  \\aa-xxxx-yy
      
  select * from x1 where xName like '\\%';
    -- this should match any string with a leading \, however, no rows are returned.
  
  select * from x1 where xName like '\\\%';
    -- this returns 1 row, but it should not.
  
  select * from x1 where xName like '\\\\%';
    -- this works fine, as it should

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

This is described in the manual:
http://www.mysql.com/doc/en/String_comparison_functions.html