[balinor]

That's why the query didn't work for you. Here's one that should:

update xcart_thumbnails
set image_path = replace(image_path,'testcart.co.uk','realsecurity. co.uk')

See how that works? It is essentially a find and replace query...first one is the old one, second one is the new one.