MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.27

CREATE TABLE County (
Name varchar(30 ) 
 );

insert into County values
('Test1'),
('Test2'),
('Tust3'),
('TeAt4'),
('TeAt5'),
('TUst6'),
('Tust7');

SELECT *
FROM County
WHERE LOWER(Name) LIKE "%u%";

Name

Tust3

TUst6

Tust7

SELECT * 
FROM County 
WHERE 
    BINARY name like '%u%' ;

Name

Tust3

Tust7