Cacher is the code snippet organizer for pro developers

// Lis, I suggest performing the search and then create a query for each table row it's found in, thus only having to do it once, and hit them all at the same time.

update wp_posts set post_content = replace(post_content,'stage9.brightdesign.co.uk','www.ceramictilesupplies.co.uk');
update wp_options set option_value = replace(option_value,'stage9.brightdesign.co.uk','www.ceramictilesupplies.co.uk');