I have 2 tables:
1. 'dbcontact' with column name = 'contwebsite' containing urls
2. 'dbcontactemails' with column name = 'contemail' containing email addresses
I would like to strip out all characters preceeding and including the '@' symbol in the 'contemail' column, append 'www.' to this value and write or update the new value to the 'contwebsite' column.
So column value 'email@example.com' will write 'www.ici.com'
to the dbcontact.contwebsite column
Any help very much appreciated.