mysql query all entries which 'dont' match

hazno · #1 (**permalink**) 04-06-2009

I am trying to query a list of hosts and extract all entries which 'dont' match.

Code:

SELECT LOGS.host, GOODLIST.host FROM LOGS,db.GOODLIST WHERE (LOGS.host <> GOODLIST.host)

When I use this query, it is very very slow. Matching the host with the GOODLIST.host works great and fast but when I use <> to get the hosts which DONT match, it doesnt work as expected. Am I using the wrong approach?

thanks & regards

vidyadhar85 · #2 (**permalink**) 04-07-2009

you can try

Code:

SELECT LOGS.host, GOODLIST.host FROM LOGS,db.GOODLIST WHERE GOODLIST.host NOT IN (SELECT LOGS.host from LOGS);

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
New MySQL Enterprise with Query Analyzer Boosts Database Application Performance	iBot	MySQL DevZone RSS	0	11-19-2008 04:10 AM
MySQL Query Analyzer: Interview with Mark Matthews	iBot	MySQL DevZone RSS	0	11-10-2008 10:50 PM
How to query one to many mysql	pinkgladiator	High Level Programming	0	10-30-2008 01:45 PM
mysql query browser issue	venhart	UNIX and Linux Applications	3	09-18-2008 07:05 AM
sed command to match log entries	jambesh	Shell Programming and Scripting	4	07-23-2008 03:08 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by