Advertisement
qwidjib0

MySQL Contractions Fix

Dec 8th, 2011
681
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.51 KB | None | 0 0
  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.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement