database query for listing users

[chikuru]

1. Whats the database query for listing users with ICQ with more than 1 post?

2. Whats the database query for listing users with ICQ with 0 post?

[kh99]

I guess when you say "with ICQ" you mean that icq is not blank? Then maybe this:

SELECT username FROM user WHERE icq > '' AND posts > 1

and change to posts < 1 for the second query. That leaves out users with exactly 1 post, I'm not sure if you meant to do that or not. I'm guessing you meant "one or more posts" for the first query, in which case you'd use posts >= 1.