Cod: Selectaţi tot
UPDATE `root_wp`.`wp_posts` SET `post_content` = regex_replace('post_content','/<[^>]+>(.*)</a+>/','-aici era link-');
am gasit ceva info aici ...
http://www.nacodes.com/2013/01/29/Create-Function-MySQL-Regex-replace-TRIM-for-MySQL