By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (txt VARBINARY(32));
INSERT INTO test VALUES ('Hello, John'), ('hello, Jim');
SELECT * FROM test WHERE txt LIKE '%Hello%';
SELECT * FROM test WHERE txt LIKE '%Hello%' COLLATE utf8mb4_0900_ai_ci;
Records: 2 Duplicates: 0 Warnings: 0
| txt |
|---|
| Hello, John |
| txt |
|---|
| Hello, John |
| hello, Jim |