select * from expense ee where ee.pro_ype = processType and ee.cost_type in ( SELECT tt.value FROM t_enum tt where tt.enum_name = processType ) ;
processType 为传进来的参数,相当于根据传进来的值分别得到不同的查询语句:
1. select * from expense ee where ee.pro_ype = 1 and ee.cost_type in ( 1,2)
2. select * from expense ee where ee.pro_ype = 1 and ee.cost_type in ( 2)
可用 instr 函数替代
select * from expense ee where ee.pro_ype = processType and instr(costType,ee.cost_type) = 1; // costType 的内容是否包含了cost_type的值