LIKE, IN and BETWEEN · LIKE, IN dan BETWEEN
Matching text patterns with LIKE
= only matches text exactly. To match a pattern, use LIKE with two wildcards:
%stands for any run of characters (including none)_stands for exactly one character
'S%' means "starts with S". '%a%' means "contains an a". '_o%' means "an o as the second letter".
Mencocokkan pola teks dengan LIKE
= hanya mencocokkan teks persis. Untuk mencocokkan pola, gunakan LIKE dengan dua wildcard:
%mewakili serangkaian karakter apa pun (termasuk kosong)_mewakili tepat satu karakter
SELECT name FROM student WHERE name LIKE 'S%';
'S%' berarti "dimulai dengan S". '%a%' berarti "berisi a". '_o%' berarti "o sebagai huruf kedua".
Lists and ranges: IN and BETWEEN
Two more handy tests:
IN (…)matches any value in a list:WHERE form IN ('11A', '11C')BETWEEN low AND highmatches a range, including both ends:
Both are shorter than writing several ORs.
Daftar dan rentang: IN dan BETWEEN
Dua uji tambahan yang berguna:
IN (…)cocokkan nilai apa pun dalam daftar:WHERE form IN ('11A', '11C')BETWEEN low AND highcocokkan rentang, termasuk kedua ujungnya:
SELECT name, score FROM student WHERE score BETWEEN 70 AND 90;
Keduanya lebih pendek daripada menulis beberapa ORs.
Common mistakes
- In
LIKE,%matches any text:'A%'means "starts with A". BETWEEN a AND bincludes both ends.
Kesalahan Umum
- Dalam
LIKE,%cocokkan teks apa pun:'A%'berarti "dimulai dengan A". BETWEEN a AND bmencakup kedua ujung.
Pattern & range filters · Filter pola & rentang
LIKE / IN / BETWEEN are all WHERE — they keep matching rows. · LIKE / IN / BETWEEN semuanya adalah WHERE — mereka menyimpan baris yang cocok.
Show the name of every student whose name contains the letter a. Use LIKE with %. · Tampilkan name setiap siswa whose name mengandung huruf a. Gunakan LIKE dengan %.
Click Run to see the output here. · Klik Jalankan untuk melihat output di sini.
Show the name and score of students whose score is between 70 and 90 (inclusive). Use BETWEEN. · Tampilkan name dan score siswa whose score is antara 70 dan 90 (termasuk). Gunakan BETWEEN.
Click Run to see the output here. · Klik Jalankan untuk melihat output di sini.