Mysql - Select words from specified text

[aedales]

I have a table contains 413,000 places name (Pris, London,...) is there a way (query) to select locations from specified text.for example:" Transport for London (TfL) is in talks with its American, Australian and European partners about issuing a single contactless card for Paris, New York".I want a query to get:\[code\]* London* Paris* New York\[/code\]I tried \[code\]SELECT name FROM coutries WHERE ("Transport for London (TfL) is in talks with its American, Australian and European partners about issuing a single contactless card for Paris, New York") LIKE CONCAT('%', name, '%');\[/code\]it's slow and don't give the exact word like (Paris, New York, Euro, York ...)How can I get exact the exact word ?