mysql query all entries which 'dont' match

Linux and Unix-Like UNIX and Linux Applications
1

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

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

2

you can try

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