Sequence NODE_284
Easy

Search Using LIKE and Wildcards

SQL
Technical Specification

Write a query to find all users whose name starts with 'Ha' and email contains 'gmail'.

Input/Output Samples
Input:pattern Ha% and %gmail%
Output:Matching users
Optimal Logic Path
SELECT *
FROM users
WHERE 
  name LIKE 'Ha%'
  AND email LIKE '%gmail%';
Architectural Deep-Dive
LIKE with % lets you match prefixes, suffixes, and substrings in text fields.