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%'