mysql command

mysql> select apId, mac from zdap where deviceId=78 and state=1 and visible=1 and model='zf7942';

select * from zdap where mac='00:a3:00:00:01:60';

select * from zdap where deviceId=78 and state=1 and visible=1;
select count(*) from zdap where visible=1 and state=0;
mysql> select count(*) from zdap where visible=1;
mysql> select count(*) from zdap where visible=1 and meshAPType='RAP'
mysql> select count(*) from zdap where visible=1 and meshAPType='MAP';
mysql> select count(*) from zdap where visible=1 and meshAPType='LAP';
mysql> select count(*) from zdap where visible=1 and meshAPType=NULL;
mysql> select count(*) from zdap where state=1; =>Approval
mysql> select count(*) from zdap where state=2; => Approval Pending