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.

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

Updated