mysql> select * from weekly where btype = 'F' and day = '0' order by keyno limit 2; +-------+-------+------------+-----+ | keyno | btype | last | day | +-------+-------+------------+-----+ | 8 | F | 2003-09-28 | 0 | | 58 | F | 2003-09-28 | 0 | +-------+-------+------------+-----+ 2 rows in set (0.02 sec)