How add column order in careers table???

Question

this table i want to create

job_id            dynamic
Jobs Title        text
Job Description   text
job_Order         combo box to choose after what job 
                    or at first position in the website

i create form to add job and i want to create combo box to choose how will view in first position in career page. i using job_id to choose first position and when select data will call order by job_order

this is true or another solution

thank you

Answer 1

What I'm reading is this: The user will add a job on one page using job_id as the reference. You're question is how to sort the jobs on the career page? Can you not just "ORDER BY job_Order" when retrieving the data to display on the careers page?

Answer 2

Try:

select *, case when job_Order is null then 1 else 0 end as Rank
from job
order by Rank, job_Order, job_id