Is order by last x column possible in mysql query ?

[plusnplus]

Hi..,

 

Is order by last x column possible in mysql query ?

 

my query is like:

select * from table1 order by col_a, col_b, col_c

 

every month I need to change the order like:

select * from table1 order by  col_b, col_c,col_d

 

because i add another column in the table.

 

 

 

[Mchl]

If you need to add a new column to your table each month, something is seriously wrong with your database design.

 

Database is not a spreadsheet. Please read this:

 

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

[plusnplus]

If you need to add a new column to your table each month, something is seriously wrong with your database design.

 

Database is not a spreadsheet. Please read this:

 

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

 

So it is not possible to order by last x column in mysql query ?

[Mchl]

No, it is not possible either in MySQL, or in any other SQL falvor that I know of.

[fenway]

So it is not possible to order by last x column in mysql query ?

What does that even mean?