SELECT * FROM `users` WHERE email LIKE '%gmail%'

The number of retrieved records is: 8

Alejandro | rodri885@gmail.com

Angel | jasso123@gmail.com

Jane | garcia@gmail.com

Jane | doe@gmail.com

John | doeJ@gmail.com

John | doeJ@gmail.com

John | doeJ@gmail.com

John | doeJ@gmail.com