UPDATE table_1
SET col_1= REPLACE(col_1, AAA, zzz)
WHERE col_1 like 'AAA%'

 

Vlastimil Pošmura, 2019