My SQL replace strings with other string in a table
So you want to go through all your content in lets say Joomla and replace a string or character with something else.
Lets say you have french characters and want to replace with the html entity version.
UPDATE `jos_content` SET `introtext` = REPLACE(`introtext`, 'À','& Agrave;');
UPDATE `jos_content` SET `fulltext` = REPLACE(`fulltext`, 'À','À');
Formula:
UPDATE TableName SET TableColumnName = REPLACE( TableColumnName , 'Find Me','replace with this');