sqlzoo刷题笔记-05 | SELECT names

网址：https://sqlzoo.net/wiki/SELECT_names

1、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        查找以 Y 开始的国家/地区。

SELECT name 
FROM world
WHERE name LIKE 'Y%'

2、Find the countries that end with y.                 查找以 y 结束的国家/地区。

SELECT name 
FROM world
WHERE name LIKE '%Y'

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

Find the countries that contain the letter x.                 查找包含字母 x 的国家/地区。

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

4、Iceland,