You’ve just learned how to restrict which rows you want to display, using a range of methods such as the equal to or greater than. Each of these methods checks a column against another value. This other value is checked using an “exact match.” The exact value that you specified is used to perform the check.
For example, consider this WHERE clause:
WHERE last_name = 'SMITH'
This WHERE clause will return all rows where the last_name is equal to 'SMITH'. It does not return records where the last_name is any of the following values:
Smith
SMITHERS
SMITHSONIAN
Naismith
SMIT
This is what an ...
