IntermediateWHERE & Filtering

Filter employees using REGEXP pattern for email

The query

SQL

SELECT first_name, last_name, email
FROM employees
WHERE email ~* '^[a-z0-9._%+-]+@xperi.com$';

Tested against PostgreSQL 16

Note

“~ is regex match (case-sensitive), ~* is case-insensitive. Use for complex patterns.