MySQL: remove special character from DB field

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

Your email address will not be published.