SELECT in mysql using column number instead of name

Question

Is there any way to do something like :

SELECT * FROM TABLE WHERE COLUMN_NUMBER = 1;

?

Answer 1

No, you can't. Column order doesn't really matter in MySQL. See the below question for more details.

mysql - selecting values from a table given column number