Advertisement
qwidjib0

MySQL Fix Smart Quotes

Dec 8th, 2011
1,515
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  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,"’","'");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement