I have a table contains 300 locations 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:
London
Paris
New York
I tried: \[code\]SELECT name FROM coutries WHERE name IN ("Transport for London (TfL) is in talks with its American, Australian and European partners about issuing a single contactless card for Paris, New York")\[/code\] but no chance!, can anyone help please?
