Ok after a bit of RTPT (reading the previous Threads!!) here is my answer
UPDATE events SET url = REPLACE(url, "moon", "sun")
Best Regards
Marc P Summers
Canterbury City Council
UPDATE events SET url = REPLACE(url, "moon", "sun")
Best Regards
Marc P Summers
Canterbury City Council