MySQL Command to Remove Special Characters

what is the mysql command to remove all occurrences of some character like †in particular column of tableA in databaseA . this column is a text area 开发者_运维知识库column whose each row contains a paragraph of text.

REPLACE should work.

Take a good look at what you can do with strings.

Example:

UPDATE tableA 
SET column = REPLACE( colummn, 'â€', 'replacement string' );

This should do the job.

Good luck!