regular expression mysql

Question

I am writing a mysql select with regxp like this

SELECT name FROM employees WHERE name REGEXP '^A'

what is the regular expression syntax for this:

any record that contains gmail.com

thanks

Answer 1

I wouldn't use a REGEXP here:

SELECT name FROM employees WHERE name LIKE '%gmail.com%';

Cheers

Answer 2

Is this what you're looking for?

REGEXP '@gmail\.com$'