I have a table called "car" with a column called "region". Half of the entries in the region column have an entry that say "US". The other half of the entries have no entry at all for the region column.
I want to issue the update command to say "where the region column does not = US, set it to UK;
I have been playing around with different variations of the below but cannot seem to get it to work. Do you have any suggestions please?