mysql 判断区间是否存在交集和并集 

                (grow_range_start <![CDATA[ < ]]> #{growRangeStart} and grow_range_start <![CDATA[ >= ]]> #{growRangeStart})or
                (grow_range_start  <![CDATA[ < ]]> #{growRangeEnd}  and grow_range_end <![CDATA[ >= ]]> #{growRangeEnd}) or
                (grow_range_start <![CDATA[ > ]]> #{growRangeStart} and grow_range_end <![CDATA[ <= ]]> #{growRangeEnd})

 

posted @ 2020-07-07 18:24  turbozhang  阅读(1077)  评论(0)  编辑  收藏  举报