More Data Filtering!

As you've seen, you can use the WHERE clause to filter text data. However, so far you've only been able to filter by specifying the exact text you're interested in. In the real world, often you'll want to search for a pattern rather than a specific text string.

In SQL, the LIKE operator can be used in a WHERE clause to search for a pattern in a column. To accomplish this, you use something called a wildcard as a placeholder for some other values. There are two wildcards you can use with LIKE:

The % wildcard will match zero, one, or many characters in text. For example, the following query matches companies like 'Data', 'DataC' 'DataCamp', 'DataMind', and so on:

SELECT name
FROM companies
WHERE name LIKE 'Data%';

The _ wildcard will match a single character. For example, the following query matches companies like 'DataCamp', 'DataComp', and so on:

SELECT name
FROM companies
WHERE name LIKE 'DataC_mp';

You can also use the NOT LIKE operator to find records that don't match the pattern you specify.

Got it? What, do you think, would be the result of the following query?

SELECT *
FROM clients
WHERE education LIKE 'basic %'

Possible answers

You retrieve all records from the clients table where university or high school is listed as education.

You retrieve all records from the clients table where basic X-y education is listed.

Exercise

More Data Filtering!

Instructions

Possible answers