mysql if查询语句

mysql if查询语句

mysql判断语句语法问题!!!

应该这样写吧:
SELECT COUNT(*) FROM tougao_record WHERE accept_company_id=100 AND channel_type=1 AND check_status=6