SQL/select_names.sql at master · muhenge/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
SELECT name FROM world WHERE name LIKE 'Y%'

SELECT name FROM world WHERE name LIKE '%y'

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

SELECT name FROM world WHERE name LIKE '%land'

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

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

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

SELECT name FROM world WHERE name LIKE '_t%' ORDER BY name

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

SELECT name FROM world WHERE name LIKE '____'

SELECT name FROM world WHERE name = capital

SELECT name FROM world WHERE capital = concat(name, 'City')

SELECT capital, name FROM world WHERE capital LIKE concat('%', name, '%')

SELECT capital, name FROM world WHERE capital LIKE concat(name,'_%')

SELECT name, REPLACE(capital, name, '') FROM world WHERE capital LIKE concat(name,'_%')