php - Mysql - Select words from text -

i have table contains 300 locations name (pris, london,...) there way (query) select locations specified text.

for example:

" transport london (tfl) in talks american, australian , european partners issuing single contactless card paris, new york".

i want query get:

• london
• paris
• new york

i tried: select name coutries name in ("transport london (tfl) in talks american, australian , european partners issuing single contactless card paris, new york")

but no chance!, can please?

select name  coutries  ("transport london (tfl) in talks american, australian , european partners issuing single contactless card paris, new york") concat('%', name, '%'); 

in different thing.