-- 1 select * from transinfo where type='支取' order by money ; -- 2 select * from transinfo where remark='' order by transDate desc ; -- 3 select * from transinfo where type regexp '转入|转出' ; -- 4 select * from transinfo where transDate regexp '2019-07-05'; -- 5 select * from transinfo where transDate regexp '2019-06-20' and cardNo = 002; -- 6 select * from transinfo where type = '转出' and money > 500;