what is the mysql command to remove all occurances of some charachter like †in particular collumn of tableA in databaseA

Question

what is the mysql command to remove all occurances of some charachter like †in particular collumn of tableA in databaseA . this collumnn is a text area collumn whose each row contains a paragraph of text.

Answer 1

REPLACE should work.

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

Example:

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

This should do the job.

Good luck!