sql statement show all emails with dome code example

Example: sql statement show all emails with dome

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