daily pastebin goal
18%
SHARE
TWEET

MySQL Fix Smart Quotes

qwidjib0 Dec 8th, 2011 1,018 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top