By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table name ( name varchar(20));
insert into name (name) values ('A*bc'),('*bc*e'),('apa');
select * from name;
| name |
|---|
| A*bc |
| *bc*e |
| apa |
UPDATE name SET name = REGEXP_REPLACE (name, '\\*', '')
select * from name;
| name |
|---|
| Abc |
| bce |
| apa |