sql order by clause

Question

Ok so in my database I have,

1,2,3,4

But what I really want is,

2,1,4,3.

so how do I order a column against a predefined set of sequence of strings or values?

Answer 1

Create a order by column, and order the results based on that.