LIKE Operator

SQL LIKE Operator

LIKE operatori WHERE klauzasida ustunda belgilangan shablon bo'yicha qidiruv o'tkazish uchun ishlatiladi.

LIKE operatori bilan birga ishlatiladigan ikki ta'rifdagi wildcard mavjud:

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

Quyidagi jadval Customers jadvalidan olingan:

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	Alfreds Futterkiste	Maria Anders	Obere Str. 57	Berlin	12209	Germany
2	Ana Trujillo Emparedados y helados	Ana Trujillo	Avda. de la Constitución	México D.F.	05021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	05023	Mexico
4	Around the Horn	Thomas Hardy	120 Hanover Sq.	London	WA1 1DP	UK
5	Berglunds snabbköp	Christina Berglund	Berguvsvägen 8	Luleå	S-958 22	Sweden

% wildcardi har qanday sonli belgilarni ifodalaydi, nol belgini ham.

Misol: L harfi bilan boshlangan shaharlar:

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

_ wildcardi bitta belgi ifodalaydi.

Misol: L harfi bilan boshlangan va nd bilan tugagan shaharlar:

SELECT * FROM Customers
WHERE City LIKE 'L_nd';

Bir nechta shartlarni birlashtirish uchun AND yoki OR operatorlaridan foydalaning.

Misol: a yoki b harfi bilan boshlangan barcha mijozlar:

SELECT * FROM Customers
WHERE CustomerName LIKE 'a%' OR CustomerName LIKE 'b%';

Ma'lum bir harf yoki ibora bilan boshlanuvchi yozuvlarni qaytarish uchun, harf yoki iboraning oxiriga % qo'shing.

Misol: La harfi bilan boshlanuvchi mijozlar:

SELECT * FROM Customers
WHERE CustomerName LIKE 'La%';

Ma'lum bir harf yoki ibora bilan tugaydigan yozuvlarni qaytarish uchun, harf yoki iboraning boshiga % qo'shing.

Misol: a bilan tugaydigan mijozlar:

SELECT * FROM Customers
WHERE CustomerName LIKE '%a';

Ma'lum bir harf yoki ibora ichida bo'lgan yozuvlarni qaytarish uchun, har ikki tomonida % qo'shing.

Misol: or iborasi bor mijozlar:

SELECT * FROM Customers
WHERE CustomerName LIKE '%or%';

Har qanday wildcard, masalan, % va _, boshqa wildcardlar bilan birgalikda ishlatilishi mumkin.

Misol: a bilan boshlanuvchi va kamida 3 belgi uzunlikka ega bo'lgan mijozlar:

SELECT * FROM Customers
WHERE CustomerName LIKE 'a__%';

Misol: Ikkinchi pozitsiyada r harfi bo'lgan mijozlar:

SELECT * FROM Customers
WHERE CustomerName LIKE '_r%';

Agar hech qanday wildcard ko'rsatilmasa, ibora aniq mos kelishi kerak.

Misol: Ispaniyadan bo'lgan barcha mijozlar:

SELECT * FROM Customers
WHERE Country LIKE 'Spain';