Learn SQL in a Month of Lunches

7 Filtering with wildcards and null values

The preceding chapters are filled with different ways to filter the data returned by your queries using numerous comparison operators. We’ve worked with many methods for filtering on one or more values of equality or inequality using known values or ranges of values. Let’s take one more chapter to examine some interesting ways to search for less specific data.

We’ll look at how to filter data when we don’t know the exact values to be searched. Instead of searching for specific values, we’ll search for patterns of values. This approach can be incredibly useful when we want to look for a list of products that have specific text like tomato or cable in the name, or when we want a list of all customers whose ...