mysql - Maria DB Update and replace -

i'm getting error message when run this:

update catalog_product_entity_text set value = replace (value, 'xxxxx')  value 'yyyyy';  

error: #1064 - have error in sql syntax; check manual corresponds mariadb server version right syntax use near ')' @ line 1

any ideas?

thanks

i obtained same error expression:

update catalog_product_entity_tex      set value = replace (value, 'yyyyy', 'xxxxx')      value '%yyyyy%'; 

the solution using alias:

update catalog_product_entity_tex c      set c.value = replace (c.value, 'yyyyy', 'xxxxx')      c.value '%yyyyy%';