MySQL/MySQL_Like.sql at main · django-cheng/MySQL · 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
30
31
32
33
34
35
-- like
select * from passengers;
select * from passengers where name = 'Braund, Mr. Owen Harris';

-- find william
select * from passengers where name = 'William';
select * from passengers where name like 'William';

-- wildcard %
select * from passengers where name like '%William%';
select * from passengers where name like '% William %' and sex = 'male';

#select * from passengers where name like '%Williams,%'; (X)
select * from passengers where name like 'Williams,%';

-- find Smith
select * from passengers where name like '%Smith,%';
select * from passengers where name like 'Smith,%';

-- find )
select * from passengers where name like '%)';

-- double like
select * from passengers where name like '%williams%' and name like '%charles%';
select * from passengers where name like '%williams%' or name like '%charles%';

-- find digital place
select * from passengers;
select * from passengers where ticketid like '_';
select * from passengers where ticketid like '__';
select * from passengers where ticketid like '___';

-- practice p135 --
select * from passengers where ticketid like '__' and name like '% William %' and sex = 'male';
-- practice p135 --