I have a table with the clients' domain names.
I need to add a column that has the domain name extension (ie. '.com', '.uk', etc.)
I only need the last piece after the last decimal (ie. '.uk' ... I don't need '.co.uk')
I already have a column with the full domain name. How would I build a query with string functions to make this update?
I'm trying to avoid a series of queries, so that this one query will be reusable in the future as new records are added.