[Andreas]

[sql]
SELECT user.*
FROM user
LEFT JOIN userfield ON (userfield.userid=user.userid)
WHERE (fieldX & 1) OR (fieldx & 2) OR (fieldX & 4)
[/sql]

Alternatively, you could add up the values
[sql]
SELECT user.*
FROM user
LEFT JOIN userfield ON (userfield.userid=user.userid)
WHERE (fieldX & 7)
[/sql]

This query should be more efficient.

Option 1 = 1
Option 2 = 2
Option 3 = 4
Option 4 = 8
and so on