[Marco van Herwaarden]

Originally Posted by Sculli

Edit:
Oops, not quite working, returned a total of 18 users, and on the board I see some without a sig that are not in the listed 18. Also, 18 out of 3,200+ doesn't seem quite right.

Makes me wonder whether I would get different results if I were to run this from mysql> rather than through the board, will test that out tonight.

Try:
[sql]SELECT user.username
FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON (user.userid = usertextfield.userid)
WHERE usertextfield.signature = ""
OR usertextfield.signature = NULL
[/sql]

It should make no difference if you run from ACP or mysql directly.