select * from card where openDate>'2019-04-01';
select * from card where money between 10000 and 20000;
select * from card where password like '123%';
select * from card where userId='106';
select * from card where isLock!='0';
select * from card where openDate BETWEEN '2019-03-01' and '2019-03-31';
select * from card where openDate between '2019-03-01' and'2019-04-30';