This query is quite helpful when you moving from development machine to production where your table content is full of dozen 'http://localhost/' links.
Syntax
UPDATE [table] SET [column] = REPLACE( [column], [old_value], [new_value] ) WHERE [column] LIKE [old_value];
