How to remove an unwanted multiple character (e.g. &,%, @) from database records

Question

I have a problem removing a few unwanted characters in a MySql database as too large. Is there access to the script to remove this character?

Example of a record with several characters: -

[]No. 11, Persiaran Bukit [] Satu&[]Taman @Sri %Nibong 

Answer 1

use the REPLACE function.

 UPDATE tablename SET ColName = REPLACE(REPLACE(REPLACE(Colname, '&', ''), '@', ''), '%', '') 

Answer 2

I suggest here to prepare a table containing all possible unwanted characters, and then process them in a single select request using the replace function.