Hi, I have the following entries in a table:- http://www2.mysite.com/location1/sublocation2 http://www2.mysite.com http://www2.mysite.com/location1 All I want to do is try for a global change from www2 to www, is it possible and how would I go about it? Thanks for the help.. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php