Maintaining data with replace

Hi

The following can be used to do a substitute of text.

In the following example full website URL's are being substituted by relative

update tbl_websitepages set page_content=replace (page_content,'http://www.website.co.uk/website/cms/','/website/images/cms/');

Unfortunately no regular expressions are possible