WHERE Clause

I have a table that contains recorded logins to a site. Each record has the username which is their email address, the time, the date and the IP they logged in from. Within the query to pull all this data out, I want to skip over any records where the email address contants xxxxx.com.
How would I go about doing that?
LVL 8
akalbfellAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rik-LeggerConnect With a Mentor Commented:
SELECT * FROM table WHERE email_address NOT LIKE '%xxxxx.com';

Open in new window

0
 
k_romychConnect With a Mentor Commented:
add next string to WHERE
   AND emailaddress NOT LIKE "%xxxxx.com%"
0
 
akalbfellAuthor Commented:
Thanks guys. Just what I needed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.