Solved

WHERE Clause

Posted on 2011-03-16
3
366 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:akalbfell
3 Comments
 
LVL 2

Assisted Solution

by:k_romych
k_romych earned 250 total points
ID: 35149966
add next string to WHERE
   AND emailaddress NOT LIKE "%xxxxx.com%"
0
 
LVL 8

Accepted Solution

by:
Rik-Legger earned 250 total points
ID: 35149976
SELECT * FROM table WHERE email_address NOT LIKE '%xxxxx.com';

Open in new window

0
 
LVL 8

Author Closing Comment

by:akalbfell
ID: 35150046
Thanks guys. Just what I needed.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now