SQL - LIKE

SQL LIKE

SQL LIKE 문은 컬럼에서 지정된 패턴을 찾는 것을 말한다.

실제 예를 보면 더 이해가 쉽다. 

SQL LIKE Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;

1. 

SELECT * FROM Customers
WHERE City LIKE 's%';

Customers 테이블에 있는 City 컬럼에서 s로 시작하는 단어를 찾는다. 

결과:

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
12	Cactus Comidas para llevar	Patricio Simpson	Cerrito 333	Buenos Aires	1010	Argentina
18	Du monde entier	Janine Labrune	67, rue des Cinquante Otages	Nantes	44000	France
26	France restauration	Carine Schmitt	54, rue Royale	Nantes	44000	France
31	Gourmet Lanchonetes	Andr� Fonseca	Av. Brasil, 442	Campinas	04876-786	Brazil

2. 

SELECT * FROM Customers
WHERE City LIKE '%s';

Customers 테이블에 있는 City 컬럼에서 s로 끝나는 단어를 찾는다. 

결과:

7	Blondel p�e et fils	Fr��ique Citeaux	24, place Kl�er	Strasbourg	67000	France
15	Com�cio Mineiro	Pedro Afonso	Av. dos Lus�das, 23	S� Paulo	05432-043	Brazil
21	Familia Arquibaldo	Aria Cruz	Rua Or�, 92	S� Paulo	05442-030	Brazil
30	Godos Cocina T�ica	Jos� Pedro Freyre	C/ Romero, 33	Sevilla	41101	Spain

3. 

SELECT * FROM Customers
WHERE Country NOT LIKE '%land%';

Customers 테이블에 있는 City 컬럼에서 가운데가 land인 단어를 제외한 나머지를 찾는다.

결과:

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Alfred Schmidt	Obere Str. 57	Hamburg	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constituci� 2222	M�ico D.F.	05021	Mexico
3	Antonio Moreno Taquer�	Antonio Moreno	Mataderos 2312	M�ico D.F.	05023	Mexico
4	Around the Horn	Thomas Hardy	120 Hanover Sq.	London	WA1 1DP	UK