Tutorial :MySQL Command to Remove Special Characters



Question:

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.


Solution:1

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!


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