# LIKE Predicate

*noun*

say it: **“LYKE PRED-ih-kit”** **/laɪk ˈprɛdɪkɪt/**

A SQL condition that matches text against a pattern, with % for any characters and \_ for exactly one.

## What does **LIKE Predicate** do in a relational database?

**LIKE Predicate** — A predicate comparing text with a pattern containing wildcard characters.

```sql
SELECT customer_id, email
FROM customer
WHERE email LIKE '%@example.com';
```

## In a sentence

- “WHERE ProductName **LIKE** 'Ch%' finds every product starting with Ch.”

Level: Apprentice · [More SQL terms at this level](https://www.ask-codey.com/glossary?category=sql&level=2)

Updated: November 9, 2026

Source: https://www.ask-codey.com/glossary/like-predicate
