Qo‘llanma · SQL
like
1 ta masala Masalalar ro‘yxatida
Nazariya
LIKE satrni andoza bo‘yicha qidiradi: % — istalgan uzunlikdagi belgilar, _ — bitta belgi.
SELECT name FROM students WHERE name LIKE 'A%'; -- A bilan boshlanadi
SELECT name FROM students WHERE name LIKE '%ova'; -- -ova bilan tugaydi
SELECT name FROM students WHERE name LIKE '%li%'; -- ichida "li" bor
SELECT code FROM rooms WHERE code LIKE 'A_1'; -- A, istalgan bitta belgi, 1
SQLite’da LIKE lotin harflari uchun katta-kichik harfni farqlamaydi. Aniq moslik kerak bo‘lsa — =.
Beginner
- Beginner