[Andreas]

The user options are just a bitfield.
From init.php

PHP Code:

// Defined constants used for user field.
$_USEROPTIONS = array(
    'showsignatures'    => 1,
    'showavatars'       => 2,
    'showimages'        => 4,
    'coppauser'         => 8,
    'adminemail'        => 16, 


So if you want to get all users which have this options enabled;:

[sql]SELECT username, email FROM user WHERE options & 16[/sql]