qwidjib0

MySQL Fix Smart Quotes

Dec 8th, 2011
1,102
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE articles SET text = REPLACE(text,'“','"');
  2. UPDATE articles SET text = REPLACE(text,'”','"');
  3. UPDATE articles SET text = REPLACE(text,"‘","'");
  4. UPDATE articles SET text = REPLACE(text,"’","'");
RAW Paste Data