How do I search users profile fields?

[Gutspiller]

I am a points system, that I call "cookies" and I am looking to find out the users that have the most cookies. How would I go about this? Is there a way I can do it in the admin control panel? I found that I can search that field, but I don't want to search for a specific number, I just want it to display all users that have anything in their cookie field besides "0"

Can somebody please help me out on how to do this? Thanks.

I have that one hack installed as well that allows my users to search as well, if that makes any difference.

[filburt1]

A query to do it:
[sql]
SELECT u.username, uf.userid FROM user u, userfield uf
WHERE u.userid = uf.userid
AND uf.fieldn != "0";
[/sql]

[Gutspiller]

Today at 08:45 PM filburt1 said this in Post #2
A query to do it:
[sql]
SELECT u.username, uf.userid FROM user u, userfield uf
WHERE u.userid = uf.userid
AND uf.fieldn != "0";
[/sql]

Do I need to change any of that?