시작일 종료일 기준 전 포함 후 체크하는 쿼리문

"select mo.*
        ,DATE_ADD(start_date,INTERVAL day DAY) as end_date,
        TO_DAYS(CURRENT_DATE)-TO_DAYS(start_date) AS start_diff_date,TO_DAYS(CURRENT_DATE)-TO_DAYS(DATE_ADD(start_date,INTERVAL day DAY)) AS end_diff_date,
        m.name as user_name
        from  ".$this->table." mo
        left join member m on(mo.member_code=m.code)
        where 1".$add_where." order by mo.code desc";

        foreach($data['list'] as $key => $val) {
            if($val['start_diff_date']<0){
               $data['list'][$key]['status3']='w';
            }else if($val['end_diff_date']>0){
               $data['list'][$key]['status3']='e';
            }else if($val['start_diff_date']>=0&&$val['end_diff_date']<=0){
               $data['list'][$key]['status3']='i';
            }
        }