I have to search in a table and update them by the new one:

the table contains data about locations:

Table1

```
name  | location
---------------
rolf  | India Mumbai
Jorgee| India Agra
ahmed | Iraq
jose  | France Paris
Morata| Italia Milan

```

i need to update it to get the next result:

```
name  | location
---------------
rolf  | Asia
Jorgee| Asia
ahmed | Asia
jose  | Europe
Morata| Europe

```

I tried with this query but i didn't know how to create it correctly with update set:

```
Case
When REGEXP_MATCHES(location, ".*India.*|.*Japan.*|.*UAE.*|.*Qatar.*|.*Syrie.*|.*Iraw.*") then "Asia" 
When REGEXP_MATCHES(location, ".*Colombia.*|.*Argentina.*|.*Peru.*|.*Brazil.*") then "Lat-America" 
When REGEXP_MATCHES(location, ".*France.*|.*Germany.*|.*Spain.*") then "Europe" 

```

as am new to SQL i don't know how to do it ?

have anyone idea how to update a column based on many conditions ?