-- 1 select * from card where openDate > '2019-04-01'; -- 2 select * from card where money between 10000 and 20000; -- 3 select * from card where password like '123%'; -- 4 select * from card where userId = 106; -- 5 select money from card where islock =1; -- 6 select * from card where openDate like '2019-03-%'; -- 7 select * from card where openDate regexp '2019-0[3|4].';