Re: LIKE not working as expected

[Peter Brawley]

To show no backslashes, insert 1, to show 1 insert 2, to show 2 insert 4, &c ...

select version(), @@sql_mode;
+-----------+--------------------------------------------+
| version() | @@sql_mode                                 |
+-----------+--------------------------------------------+
| 8.0.19    | STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION |
+-----------+--------------------------------------------+
drop table if exists data;
create table data( stringvalue varchar(32) );
insert into data set stringvalue="Thor\'s Hammer";
insert into data set stringvalue="Thor\\'s Hammer";
select * from data;
+----------------+
| stringvalue    |
+----------------+
| Thor's Hammer  |
| Thor\'s Hammer |
+----------------+
select * from data WHERE stringValue = "Thor\'s Hammer";
+---------------+
| stringvalue   |
+---------------+
| Thor's Hammer |
+---------------+
select * from data WHERE stringValue = "Thor\\'s Hammer";
+----------------+
| stringvalue    |
+----------------+
| Thor\'s Hammer |
+----------------+