Remove anything from table's column in mysql using query

If you want to remove anything from your table column values. Suppose in yourtable have column name email and all email values have ,(comma). Example : abc@gmail.com, UPDATE YourTable SET ` email ` = REPLACE(` email `, ',' , '' ) WHERE ` email ` like '%,%' ;