Matching text patterns with LIKE

= only matches text exactly. To match a pattern, use LIKE with two wildcards:

SELECT name FROM student WHERE name LIKE 'S%';

'S%' means "starts with S". '%a%' means "contains an a". '_o%' means "an o as the second letter".

Lists and ranges: IN and BETWEEN

Two more handy tests:

SELECT name, score FROM student WHERE score BETWEEN 70 AND 90;

Both are shorter than writing several ORs.

Show the name of every student whose name contains the letter a. Use LIKE with %.

SELECT name FROM student WHERE name LIKE ...;

Click Run to see the output here.

Show the name and score of students whose score is between 70 and 90 (inclusive). Use BETWEEN.

SELECT name, score FROM student WHERE score BETWEEN ... AND ...;

Click Run to see the output here.