如何查询包含多个日期值的字段，并获取在给定时间范围内的数据？

<select id="geteventplanbycodedatelimitsimple" resultmap="eventplanrecordallmap">
    select
        epr.*
    from
        event_plan_record epr
    where
        epr.realstarttime between #{startdate} and #{enddate}
    order by epr.realstarttime desc limit #{page},#{count};
</select>

select
    epr.*
from
    event_plan_record epr
where
    substring_index('epr.realstarttime', ',', 1) between #{startdate} and #{enddate} 
    or substring_index('epr.realstarttime', ',', -1) between #{startdate} and #{enddate}
    or #{startdate} between substring_index('epr.realstarttime', ',', 1) and substring_index('epr.realstarttime', ',', -1)
    or #{enddate} between substring_index('epr.realstarttime', ',', 1) and substring_index('epr.realstarttime', ',', -1)
order by epr.realstarttime desc limit #{page},#{count};

// 假设 startDate 和 endDate 已赋值
Map<String, Object> params = new HashMap<>();
params.put("startDate", startDate);
params.put("endDate", endDate);
params.put("page", 0);
params.put("count", 10);

List<EventPlanRecord> result = sqlSession.selectList("getEventPlanByCodeDateLimit", params);