use testdb;
select count(1) from qa_log where requestUri like concat('%','gateway.do','%');
select count(1) from qa_log where requestUri like concat('%','gateway.do','%') and (status like '200' and code like '0');
select count(1) from qa_log where requestUri like concat('%','gateway.do','%') and (status not like '200' or code not like '0');