mysql> select macadd,forward,reverse,snr,forward_mer from tbl_rf where macadd='bbaa.d712.587d' and date='2008-02-18-h22-m25-s09' and forward_mer is not null; +----------------+---------+---------+--------+-------------+ | macadd | forward | reverse | snr | forward_mer | +----------------+---------+---------+--------+-------------+ | bbaa.d712.587d | 0.000 | 0.000 | 15.800 | | +----------------+---------+---------+--------+-------------+ 1 row in set (20.54 sec) mysql>