MSSQL-Server:

select city,name from PERSON
where PATINDEX('%'+rtrim(city)+'%', 'Unterhaching,London,Plauen,Berlin,Munich,Ebersberg,Garching') > 0
order by city,name