CODE EXAMPLE FOR SQL

sql statement show all emails with dome

select email
from customers
where email similar to '[0-9]{6}@gmail.com'