Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
 

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');