Matching cities and values in the Name column

It is necessary to develop a mechanism that will match the specified cities (for example, NY, Moscow) with a certain value in the Name field.

| ID | City        | Name |
|----|-------------|------|
| 1  | NY, Moscow  | #1   |
| 2  | Moscow      | #2   |
| 3  | Singapur    | #3   |