[thelist] MySQL - selecting records that are NOT in a date range...

Tris beertastic at gmail.com
Tue Nov 20 04:15:07 CST 2007


Iv'e got a table of activitives on a site.
I want to pull all user Ids of users who have NOT been logged in sept 07.

So I need to have my daterange (unix timestamp)
SELECT `UserId` FROM `activities` WHERE `Timestamp` > '1191196799' AND
`Timestamp` < '1188604800' GROUP BY `UserId`

But how can I say to MySQL: get me all users who DON'T have entries in
this range...
i can find 101 tutorials on how to get dates within a range, but not
the other way around...

Thoguhts?


-- 
Give a man a fish and he'll feed himself for a day.
Give a man a religion and he'll starve to death praying for a fish.
Anon

`We are what we pretend to be, so we must be careful what we pretend to be.`
Kurt Vonnegut

`When a person can no longer laugh at himself, it is time for others
to laugh at him.`
Thomas Szasz



More information about the thelist mailing list