Mine

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