28.2.3 Selecting Subsets

To select rows (records) based on certain criteria:
SELECT * FROM Customer WHERE State = 'CA'
Returns:

3175 Sam's Small Appliances 100 Main St. Anytown CA 98765