By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version() |
|---|
| 5.7.39 |
| cast('Li\ma' as CHAR CHARACTER SET utf8mb4) collate utf8mb4_unicode_ci like cast('li%\\ma' as CHAR CHARACTER SET utf8mb4) collate utf8mb4_unicode_ci escape '\' |
|---|
| 0 |
| cast('Li\ma' as CHAR CHARACTER SET utf8mb4) collate utf8mb4_general_ci like cast('li%\\ma' as CHAR CHARACTER SET utf8mb4) collate utf8mb4_general_ci escape '\' |
|---|
| 1 |