mysql批量替换zencart数据中的反斜杠\

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,   ‘\\"‘,‘"‘);