SELECT * FROM gjp_ledger WHERE parent = '支出';

查询出金额价格大于1000的信息
SELECT * FROM gjp_ledger WHERE money >1000;


查询出金额在2000-5000之间的账务信息
SELECT * FROM gjp_ledger WHERE money >=2000 AND money <=5000;
SELECT * FROM gjp_ledger WHERE money BETWEEN 2000 AND 5000;

查询出金额是1000或5000或3500的商品信息
SELECT * FROM gjp_ledger WHERE money =1000 OR money =5000 OR money =3500;
SELECT * FROM gjp_ledger WHERE money IN(1000,5000,3500);

查询出账务的银行有工商银行的账务信息。
SELECT * FROM gjp_ledger WHERE account LIKE "%工商%";

学习学习哦