SELECT names

name	continent
Afghanistan	Asia
Albania	Europe
Algeria	Africa
Andorra	Europe
Angola	Africa
....

Pattern Matching Strings

This tutorial uses the LIKE operator to check names. We will be using the SELECT command on the table world:

Summary

You can use WHERE name LIKE 'B%' to find the countries that start with "B".

• The % is a wild-card it can match any characters

Find the country that start with Y

SELECT name FROM world
  WHERE name LIKE 'F%'

SELECT name FROM world
  WHERE name LIKE 'Y%'

Find the countries that end with y

SELECT name FROM world
  WHERE name LIKE 'T%'

SELECT name FROM world
  WHERE name LIKE '%y'

Luxembourg has an x - so does one other country. List them both.

Find the countries that contain the letter x

SELECT name FROM world
  WHERE name LIKE 'T%'

SELECT name FROM world
  WHERE name LIKE '%x%'

Iceland, Switzerland end with land - but are there others?

Find the countries that end with land

SELECT name FROM world
  WHERE name LIKE 'T%'

SELECT name FROM world
  WHERE name LIKE '%land'

Columbia starts with a C and ends with ia - there are two more like this.

Find the countries that start with C and end with ia

SELECT name FROM world
  WHERE name LIKE 'T%'

SELECT name FROM world
  WHERE name LIKE 'C%ia'