select*from card select*from card where openDate>'2019-04-01' select*from card where money<20000 and money>10000 select*from card where password like '123%' select*from card where userID='106' select*from card where isLock=1 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'