select * from tb_member_level
where (( 70 >= integral_min and
70 <= integral_max )
or ( 79 >= integral_min and
79 <= integral_max) or ( integral_min >=70 and integral_max<= 79 ))
and flag =1 ;
输入的值是否在 70-79之间,适用于会员积分设置。
where (( 70 >= integral_min and
70 <= integral_max )
or ( 79 >= integral_min and
79 <= integral_max) or ( integral_min >=70 and integral_max<= 79 ))
and flag =1 ;
输入的值是否在 70-79之间,适用于会员积分设置。