Search⌘ K
Home
Courses
Getting Started with SQL and Relational Databases

Retrieve Data Using the like Operator

Understand how to use the SQL like operator to search for data patterns within tables. Learn how to apply wildcards to filter results by matching the beginning, ending, or containing sequences in database entries.

We'll cover the following...

The like operator

We’ll close this first chapter by learning about the like operator, which is very useful in where clauses.

Let’s look at an example. Assume that we know that the name of our customer ends with Woo, but we don’t remember the exact name. To search for customers whose name ends with Woo, we’ll use the following statement:

MySQL
select * from customers where name like '%Woo';

Note that ...