+---------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------------------+------+-----+---------+----------------+ | pollid | int(10) unsigned | NO | PRI | NULL | auto_increment | | question | varchar(100) | NO | | | | | dateline | int(10) unsigned | NO | | 0 | | | options | text | YES | | NULL | | | votes | text | YES | | NULL | | | active | smallint(6) | NO | | 1 | | | numberoptions | smallint(5) unsigned | NO | | 0 | | | timeout | smallint(5) unsigned | NO | | 0 | | | multiple | smallint(5) unsigned | NO | | 0 | | | voters | smallint(5) unsigned | NO | | 0 | | | public | smallint(6) | NO | | 0 | | | lastvote | int(10) unsigned | NO | | 0 | | +---------------+----------------------+------+-----+---------+----------------+
+---------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------------------+------+-----+---------+----------------+ | pollid | int(10) unsigned | NO | PRI | NULL | auto_increment | | question | varchar(100) | NO | | | | | dateline | int(10) unsigned | NO | | 0 | | | options | text | YES | | NULL | | | votes | text | YES | | NULL | | | active | smallint(6) | NO | | 1 | | | numberoptions | smallint(5) unsigned | NO | | 0 | | | timeout | smallint(5) unsigned | NO | | 0 | | | multiple | smallint(5) unsigned | NO | | 0 | | | voters | smallint(5) unsigned | NO | | 0 | | | public | smallint(6) | NO | | 0 | | | lastvote | int(10) unsigned | NO | | 0 | | +---------------+----------------------+------+-----+---------+----------------+
select title from forum where (options & 256)=256;