mysql批量替換zencart資料中的反斜線\

標籤：des   style   blog   color   io   ar   資料   art   div   

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

 

mysql批量替換zencart資料中的反斜線\