Tutorial :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.


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

This should do the job.

Good luck!

Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Next Post »