I need to check for only email addresses that do have the @

I have a field in a table called email_staff. It is a varchar 50 null. Some are entered as jsmith and others are entered as jsmith@companyname.org

I need a report of only the ones who have the @companyname.org I tried this sort of code but it does not work:

`Select Last_name, First_name, email_staff from staff_view

Where email_staff like '@'

WHERE email_staff LIKE '%@%'

1 Like

1 Like