MySQL - Selecting based upon the value of a single Bit

Hi,

Does anyone know if its possible to do something like:-

SELECT * FROM $table if(query_bit(flags, 2))

in a MySQL call.

Thanks


Pual