KwickClips Databases and SQL · 41 sec · free
What does '____' match?
Short answer. Any value with exactly four characters.
Which wildcard means one character?
The underscore.
LIKE wildcards
| Pattern | Finds |
|---|---|
| 'R%' | starts with R |
| '%a' | ends with a |
| '_e%' | 2nd letter e |
| '____' | exactly 4 |
Remember
| % any characters |
| _ exactly one character |
Percent or underscore in like? Percent is any characters. Underscore is exactly one. So R percent starts with R. Percent a ends with a. Four underscores is four letters. Percent is any text. Underscore is one character.
This clip is from the full lesson: SQL Operators: BETWEEN, IN, LIKE and IS NULL — 5 minutes, with the tables, the quick answers and the whole lesson in text.
Useful for: CBSE Class 12 Computer Science (083), CBSE Class 11 Informatics Practices (065), CBSE Class 11 Information Technology (802), ICSE Class 10 Computer Applications
More KwickClips from this lesson
Is 65 included in BETWEEN 65 AND 88?39 sec
What is IN a short form of?36 sec
Why does marks = NULL return no rows?42 secVoice-over is AI-generated; the script is written and checked by Kajal Ma'am. Confirm anything you plan around against your official board document. We never ask for a password or an OTP.