Quick n easy search and replace in mysql

I had to do a quick search and replace on a field that had some records with the ‘http’ bit duplicated, so this did the trick.

update `pages` SET url=(replace (url, ‘http://http://’,'http://’))