CODEWITHSUNDEEP
mysql
silverkid
silverkid

Reputation: 9583

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.

Upvotes: 2

Views: 166

Answers (1)

Jacob Relkin
Jacob Relkin

Reputation: 163318

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!

Upvotes: 2

Related Questions