mysql批量替换zencart数据中的反斜杠\
时间:2022-03-13 23:16
update products_description set products_description=replace(products_description, "\\‘","‘"); update products_description set products_name=replace(products_name, "\\‘","‘"); update categories_description set categories_name=replace(categories_name, "\\‘","‘"); update meta_tags_categories_description set metatags_title=replace(metatags_title, "\\‘","‘"); update meta_tags_categories_description set metatags_keywords=replace(metatags_keywords, "\\‘","‘"); update meta_tags_categories_description set metatags_description=replace(metatags_description, "\\‘","‘"); update meta_tags_products_description set metatags_title=replace(metatags_title, "\\‘","‘"); update meta_tags_products_description set metatags_keywords=replace(metatags_keywords, "\\‘","‘"); update meta_tags_products_description set metatags_description=replace(metatags_description, "\\‘","‘"); update products_description set products_description=replace(products_description, ‘\\"‘,‘"‘); update products_description set products_name=replace(products_name, ‘\\"‘,‘"‘); update categories_description set categories_name=replace(categories_name, ‘\\"‘,‘"‘); update meta_tags_categories_description set metatags_title=replace(metatags_title, ‘\\"‘,‘"‘); update meta_tags_categories_description set metatags_keywords=replace(metatags_keywords, ‘\\"‘,‘"‘); update meta_tags_categories_description set metatags_description=replace(metatags_description, ‘\\"‘,‘"‘); update meta_tags_products_description set metatags_title=replace(metatags_title, ‘\\"‘,‘"‘); update meta_tags_products_description set metatags_keywords=replace(metatags_keywords, ‘\\"‘,‘"‘); update meta_tags_products_description set metatags_description=replace(metatags_description, ‘\\"‘,‘"‘);