Re: LIKE not working as expected

[Robert Simpson]

No, but you _would_ expect

select * from data WHERE stringValue like '%\\\\%' escape '\\';

in my example to produce a positive result, for the same reason that this does:

select "Thor\\'s Hammer" like '%\\\\%' escape '\\';
+---------------------------------------------+
| "Thor\\'s Hammer" like '%\\\\%' escape '\\' |
+---------------------------------------------+
|                                           1 |
+---------------------------------------------+