UPDATE cms_dictionary SET source REPLACE source public tpl tpl-main ph

1
UPDATE cms_dictionary SET source=REPLACE(source, 'public/tpl/tpl-main/phtml/', '') WHERE source REGEXP 'public\/tpl\/tpl-main\/phtml\/'