UPDATE [Таблица] SET [Поле]=REPLACE([Поле],'aaa','bbb');

UPDATE wp_27_postmeta SET meta_value=REPLACE(meta_value,'https://nd-zabor.ru','https://mahachkala.nd-zabor.ru');