UPDATE cms_dictionary SET source REPLACE source public tpl tpl-landing

1
2
3
UPDATE cms_dictionary SET source=REPLACE(source, 'public/tpl/tpl-landing/phtml/', '') WHERE source REGEXP 'public\/tpl\/tpl-landing\/phtml\/'
UPDATE cms_dictionary SET source=REPLACE(source, 'public/tpl/tpl-admin/phtml/admin/', '') WHERE source REGEXP 'public\/tpl\/tpl-admin\/phtml\/admin\/'
UPDATE cms_dictionary SET source=REPLACE(source, 'public/tpl/tpl-lib/phtml/widget/', '') WHERE source REGEXP 'public\/tpl\/tpl-lib\/phtml\/widget\/'