MySQL: remove special character from DB field

In web development Tags #mysql Published 7/16/2012

UPDATE table_name SET `field_name` = REPLACE(`field_name`, '<', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, '>', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, '"', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, '%', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, ';', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, '(', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, ')', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, '\\', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, '\'', '');
UPDATE table_name SET `field_name` = REPLACE(`field_name`, '&', 'AND');

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.