I have a typo on hundreds of pages

I am using CMS 8.5.6
I have a typo, it is spelled the same on hundreds of pages. Is there an easy way to fix it? I do have phpMyAdmin if that helps?

Have a look at

2 Likes

I would use a sql to find the typo and replace it with the correct spelling.
If you search your database for the typo to determine the TableNames and ColumnNames that contain it, you could do something like this on each of them…
UPDATE TableName SET ColumnName = REPLACE(ColumnName, ‘Typo’, ‘Replacement’);

This worked perfectly! Thank you!!

Could you mark my answer as a ‘Solution’ please.