Created by Netondas.com
tilleryworldwide@gmail.com


-- Remove punctuation -- 

UPDATE wp_posts set post_name = REPLACE(post_name, ':', '');
UPDATE wp_posts set post_name = REPLACE(post_name, "'", '');
UPDATE wp_posts set post_name = REPLACE(post_name, '`', '');
UPDATE wp_posts set post_name = REPLACE(post_name, ',', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '.', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '_', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '"', '');
UPDATE wp_posts set post_name = REPLACE(post_name, ';', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '|', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '{', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '[', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '}', '');
UPDATE wp_posts set post_name = REPLACE(post_name, ']', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '+', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '=', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '*', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '&', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '%', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '^', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '$', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '#', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '@', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '!', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '~', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '(', '');
UPDATE wp_posts set post_name = REPLACE(post_name, ')', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '?', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '<', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '>', '');
UPDATE wp_posts set post_name = REPLACE(post_name, '/', '');

-- Replace double, triple, quadraple... you get the idea --

UPDATE wp_posts SET post_name = REPLACE( post_name, '--', '-' ) ;
UPDATE wp_posts SET post_name = REPLACE( post_name, '---', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '----', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-----', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '------', '-' );

-- Replace pagebreaks --

UPDATE wp_posts SET post_name = REPLACE( post_name, '<!--break-->', '<!--more-->' );

-- Remove Words --


UPDATE wp_posts SET post_name = REPLACE( post_name, '-a-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-an-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-as-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-at-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-before-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-but-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-by-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-for-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-from-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-is-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-in-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-into-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-like-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-of-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-off-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-on-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-onto-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-per-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-since-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-than-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-the-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-this-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-that-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-to-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-up-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-via-', '-' );
UPDATE wp_posts SET post_name = REPLACE( post_name, '-with-', '-' );