SHARE
TWEET

MySQL Fix Smart Quotes

qwidjib0 Dec 8th, 2011 886 Never
  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
Top