mybatis中xml怎么在where中写两个条件，而且这两个条件是或者的关系？

select from vip_member_msg where member_id = #{memberId,jdbcType=VARCHAR} and has_draw =0 and now() <= end_time and now() >= begin_time and (level_key <= #{levelKey,jdbcType=SMALLINT} or pop_type=1) order by create_time;

重点在于：and (level_key <= #{levelKey,jdbcType=SMALLINT} or pop_type=1)

版权声明：本文为weixin_43228497原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。