DROP FUNCTION IF EXISTS hj_order;
CREATE FUNCTION hj_order(ex_hj VARCHAR(20)) RETURNS INT
BEGIN
IF ex_hj = '特急' THEN
RETURN 3;
ELSEIF ex_hj = '急件' THEN
RETURN 2;
ELSEIF ex_hj = '普通' THEN
RETURN 1;
END IF;
RETURN 0;
END;
select hj_order('特急') from DUAL;
select hj_order('急件') from DUAL;
select hj_order('普通') from DUAL;
select hj_order(NULL) from DUAL;
select * from table_name order by hj_order(column_hj) desc