For example with the following query I can select all the records I want to change, but then how do do the change? e.g. change all occurences of "seven" to "four"?
SELECT * FROM `templates` WHERE `attrib_B` LIKE `seven`
This is how I think of it in pseudo code:
if `attrib_B` like `seven`: set `attrib_B` = `four`