Partial string matches with like
You can match countries following a "like" condition. Below, the condition is set to show countries who's capital starts with an S. The '%' character in a like condition can match any text.
Show the countries names which include the word 'United'
SELECT name FROM world WHERE name like '%United%'