Simple Regex mysql
Scris: Joi Sep 25, 2014 7:49 pm
Vrea sa fac replace la linkurile din post_content cu '-aici era link-' si nu imi face bine, imi face replace la toat ce e in 'post_content'
am gasit ceva info aici ...
http://www.nacodes.com/2013/01/29/Create-Function-MySQL-Regex-replace-TRIM-for-MySQL
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