General Community > Scripting Help

Query Inactive Members?

(1/1)

Minion:
Trying to get emails of board members who have not been active for quite some time.

Trying to use this:

SELECT  * FROM  `yabbse_members`.emailAddress  WHERE  `lastLogin`  > NULL;

Am I doing this right?
How do i select via the value "NULL"?

Thanks in advance!

[Unknown]:
SELECT  emailAddress FROM  `yabbse_members`  WHERE  `lastLogin` IS NOT NULL;

???

I would rather say...

SELECT emailAddress
FROM yabbse_members
WHERE lastLogin IS NULL
   OR lastLogin < UNIX_TIMESTAMP('2003-05-01');

But that would be inaccurate.

-[Unknown]

Minion:
Thanks unknown.
That did the trick.

Navigation

[0] Message Index

Go to full version