qwidjib0

MySQL Contractions Fix

Dec 8th, 2011
542
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. UPDATE articles SET text = REPLACE(text," dont' "," don't ");
  2. UPDATE articles SET text = REPLACE(text," dont "," don't ");
  3. UPDATE articles SET text = REPLACE(text," wont' "," won't ");
  4. UPDATE articles SET text = REPLACE(text," wont "," won't ");
  5. UPDATE articles SET text = REPLACE(text," cant' "," can't ");
  6. UPDATE articles SET text = REPLACE(text," cant "," can't ");
  7. UPDATE articles SET text = REPLACE(text," shouldnt' "," shouldn't ");
  8. UPDATE articles SET text = REPLACE(text," shouldnt "," shouldn't ");
  9.  
RAW Paste Data