MySQL 8.0

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

create table `table` (id int, name varchar(20))
insert into `table` values (1, 'Test')
select * from `table`


id
name


1
Test


UPDATE `table`
   SET name = CASE 
                      WHEN name like '%aa%' then 'A' 
                      WHEN name like '%er%' then 'E'
                      ELSE 'Z'
                      END
 WHERE name is not null
select * from `table`


id
name


1
Z


select * from table
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table' at line 1