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