-- SEO标签中网址替换update categories_description set categories_description=replace(categories_description, 'aaa.com','bbb.com');update meta_tags_categories_description set metatags_title=replace(metatags_title, 'aaa.com','bbb.com');update meta_tags_categories_description set metatags_keywords=replace(metatags_keywords, 'aaa.com','bbb.com');update meta_tags_categories_description set metatags_description=replace(metatags_description, 'aaa.com','bbb.com');update meta_tags_products_description set metatags_title=replace(metatags_title, 'aaa.com','bbb.com');update meta_tags_products_description set metatags_keywords=replace(metatags_keywords, 'aaa.com','bbb.com');update meta_tags_products_description set metatags_description=replace(metatags_description, 'aaa.com','bbb.com');-- 产品名与描述中网址替换update products_description set products_description=replace(products_description, 'aaa.com','bbb.com');update products_description set products_name=replace(products_name, 'aaa.com','bbb.com');-- 新闻模块中网址替换update news_articles_text set news_article_text=replace(news_article_text,'aaa.com','bbb.com');-- 批量修改后台邮箱地址update admin set admin_email =replace(admin_email,'xxxxxx@163.com','xxxxx@hotmail.com');update configuration set configuration_value =replace(configuration_value,'xxxxxx@163.com','xxxxx@hotmail.com'); -- 重置用户密码为aaaaaaa update admin set admin_pass ='bfc43b19b502b5c4b8be179d2a3a0fb5:69';