쿼리: SELECT con_calendar.cal_idx, con_calendar.cal_name, con_calendar.cal_date, con_calendar.cal_date_end, con_calendar.cal_status, con_calendar.old_name FROM con_calendar where 1 and (left(cal_date,4) = '2009' or left(cal_date_end,4) = '2009') order by cal_date asc