select job_number, case left(order_date, locate(' ', order_date) - 1) when 'JAN' then 1 when 'FEB' then 2 end case from order_log