I have a table with an email attribute. I have added a new column, called "domain". I would like to insert the domain name for each row by taking the end part of the email text (example: firstname.lastname@example.org, then the domain would be abc.com).
I would like the sql statement to go through each row in my table (20,000 records) and take the email value (example:email@example.com) and insert the domain part of the email (abc.com) into domain column FOR EACH ROW.
1. for each row select the domain part of the email value.
2. then update the domain column with the the results of step 1.