The next pages show various conditions that can be written after WHERE.
Apart from EQUAL TO (written '=') there are:
LESS THAN <
LESS THAN OR EQUAL TO <=
GREATER THAN >
GREATER THAN OR EQUAL TO >=
NOT EQUAL TO <>
For several conditions AND, OR
For negative conditions NOT
For values in a range BETWEEN x AND y
For values in a set IN (x,y,z)
For comparing partial values LIKE '%abc%',
LIKE '*abc*'
LIKE '_a_',
LIKE '?a?'
LIKE '*@?' ESCAPE '@'
For comparing similarly
sounding values SOUNDS
Query for the NULL value IS NULL
Query for a Boolean value IS TRUE
IS FALSE
Selection without condition:
SELECT city, name, firstname
FROM customer
Selection with condition:
SELECT city, name, firstname
FROM customer
WHERE city = 'Los Angeles'
