Ways to replace content in a database with regular expressions in Mysql _mysql

PS: The following is turned over, for the record, this is not the original intention, but only with the regexp, is more flexible and more convenient

The Author_url in the comment table contains www.sohu.com records, where the Sohu is replaced by Sina, a statement is done
Update comment Set Author_url=replace (author_url, ' Sohu ', ' Sina ') where Author_url REGEXP ' www.sohu.com ';

Complex substitutions with if judgments

Update comment set url=if (url REGEXP ' test.yahoo.com.cn ', replace (URL, ' www1.sohu.com ', ' www.sina.com '), replace (URL, ' Www2.yahoo.com ', ' www.sina.com ') where 1=1;