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

时间：2020-07-07 19:32:37 收藏：0 阅读：157

                (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})

原文：https://www.cnblogs.com/turbozhang/p/13262442.html