How to replace text in field using mysql request?

UPDATE table_name SET field = REPLACE(field, 'foo', 'bar') WHERE INSTR(field, 'foo') > 0;

example:

UPDATE `catalog_product_entity_text` SET value = REPLACE(value, 'Textold', 'Text new') WHERE INSTR(value, 'Textold') > 0;