MySQL BETWEEN

MySQL BETWEEN operatori

BETWEEN operatori WHERE bandida belgilangan diapazondagi qiymatlarni tanlash uchun ishlatiladi.

Diapazon inklyuziv - diapazonning boshi va oxiri qiymatlari natijalarga kiritiladi.

Qiymatlar raqamlar, matn yoki sana bo‘lishi mumkin.

Sintaksis ORASI

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Demo ma’lumotlar bazasi

Quyida Northwind namunaviy ma’lumotlar bazasidagi “Mahsulotlar” jadvalidan tanlab olingan:

ProductID	ProductName	SupplierID	CategoryID	Unit	Price
1	Chais	1	1	10 boxes x 20 bags	18.00
2	Chang	1	1	24 - 12 oz bottles	19.00
3	Aniseed Syrup	1	2	12 - 550 ml bottles	10.00
4	Chef Anton's Cajun Seasoning	1	2	48 - 6 oz jars	22.00
5	Chef Anton's Gumbo Mix	1	2	36 boxes	21.35

BETWEEN Misol

Quyidagi SQL narxi 10 dan 20 gacha bo‘lgan barcha mahsulotlarni tanlaydi:

Misol

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;

O‘zingiz sinab ko‘ring »

ORASIDA EMAS

NOT BETWEEN operatori WHERE bandida belgilangan diapazondan tashqari qiymatlarni tanlash uchun ishlatiladi.

Quyidagi SQL barcha mahsulotlarni 10 dan 20 gacha EMAS narxda qaytaradi:

Misol

SELECT * FROM Products
WHERE Price NOT BETWEEN 10 AND 20;

O‘zingiz sinab ko‘ring »

IN bilan BETWEEN misoli

Quyidagi SQL 10 dan 20 gacha bo‘lgan barcha mahsulotlarni qaytaradi. Bundan tashqari, CategoryID 1, 2 yoki 3 bo‘lishi kerak:

Misol

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20
AND CategoryID IN (1, 2, 3);

O‘zingiz sinab ko‘ring »

Matn qiymatlari orasiga misol

Quyidagi SQL "Carnarvon Tigers" va "Mozzarella di Giovanni" o‘rtasida alifbo tartibida Mahsulot nomi bo‘lgan barcha mahsulotlarni tanlaydi:

Misol

SELECT * FROM Products
WHERE ProductName BETWEEN 'Carnarvon Tigers' AND 'Mozzarella di Giovanni'
ORDER BY ProductName;

O‘zingiz sinab ko‘ring »

Quyidagi SQL "Carnarvon Tigers" va "Chef Anton’s Cajun Seasoning" o‘rtasida alifbo tartibida Mahsulot nomi bo‘lgan barcha mahsulotlarni tanlaydi:

Misol

SELECT * FROM Products
WHERE ProductName BETWEEN "Carnarvon Tigers" AND "Chef Anton's Cajun Seasoning"
ORDER BY ProductName;

O‘zingiz sinab ko‘ring »

Matn qiymatlari ORASIDA EMAS Misol

Quyidagi SQL "Carnarvon Tigers" va "Mozzarella di Giovanni" o‘rtasida emas, alifbo tartibida Mahsulot nomi bo‘lgan barcha mahsulotlarni tanlaydi:

Misol

SELECT * FROM Products
WHERE ProductName NOT BETWEEN 'Carnarvon Tigers' AND 'Mozzarella di Giovanni'
ORDER BY ProductName;

O‘zingiz sinab ko‘ring »

Namuna jadvali

Quyida Northwind namunaviy ma’lumotlar bazasidagi "Orders" jadvalidan tanlov keltirilgan:

OrderID	CustomerID	EmployeeID	OrderDate	ShipperID
10248	90	5	1996-07-04	3
10249	81	6	1996-07-05	1
10250	34	4	1996-07-08	2
10251	84	3	1996-07-08	1
10252	76	4	1996-07-09	2

Sanalar orasiga misol

BETWEEN operatori ma’lum bir sana yoki vaqt oralig‘idagi yozuvlarni filtrlash uchun foydalidir. Sana formati ma’lumotlar bazasiga mos kelishiga ishonch hosil qiling (masalan, “YYYY-AA-KK”).

Quyidagi SQL 1996 yil iyul oyida berilgan barcha buyurtmalarni tanlaydi:

Misol

SELECT * FROM Orders
WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-31';

O‘zingiz sinab ko‘ring »

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tish Kirish