Advertisement
Guest User

Untitled

a guest
Apr 29th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. UPDATE `profiles` SET `slug` = username;
  2. UPDATE `profiles` SET `slug` = REPLACE( `slug`, ' ', '-' );
  3. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '@', '' );
  4. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '(', '' );
  5. UPDATE `profiles` SET `slug` = REPLACE( `slug`, ')', '' );
  6. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '.', '' );
  7. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '{', '' );
  8. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '}', '' );
  9. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '[', '' );
  10. UPDATE `profiles` SET `slug` = REPLACE( `slug`, ']', '' );
  11. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '#', '' );
  12. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '\', '' );
  13. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '/', '' );
  14. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '=', '' );
  15. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '+', '' );
  16. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '^', '' );
  17. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '|', '' );
  18. UPDATE `profiles` SET `slug` = REPLACE( `slug`, '¸', '' );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement