Choosing Rows

WHERE keeps rows where the condition is true. There is no loop: the condition applies to every row at once, which is the mental shift from programming.

Strings use single quotes. Double quotes mean an identifier in standard SQL, so WHERE name = "Butler" may look for a column called Butler rather than the text.

Try each of these in turn: BETWEEN 1970 AND 1989, IN (1979, 1987), LIKE 'The %', and title LIKE '%Sower%'.

✦ AND binds tighter than OR

WHERE a = 1 OR a = 2 AND b = 3 means WHERE a = 1 OR (a = 2 AND b = 3), which is rarely what someone intended. Use brackets whenever you mix them. This is not a stylistic preference; it changes the answer.