Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `profiles` SET `slug` = username;
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, ' ', '-' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '@', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '(', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, ')', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '.', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '{', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '}', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '[', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, ']', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '#', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '\', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '/', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '=', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '+', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '^', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '|', '' );
- UPDATE `profiles` SET `slug` = REPLACE( `slug`, '¸', '' );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement