I have a table with a field called email.
I would like to make sure that all email are valid.
How can I build a select statement that will return all the records that do not have a .com or .net in the email field.

Select * from emails WHERE ".com" OR ".net" is not in the email field

Any help is appreciated.

Thanks