How to write a query to ensure email contains @

The underscore character ( _ ) represents any single character.

The percent sign character (%) represents a string of zero or more characters.

SELECT email
FROM YourTable
WHERE email LIKE '%_@__%.__%'