按位置简单的sql顺序

Question

Okay I have been putting this off because it has been partially working, now I need it.

I want this output:

id position
1       1       
2       2        
15      3         
16      4          

I thought this^ would do it. But I am getting the whole pages table.

SELECT * 
FROM pages 
ORDER BY position ASC

id  link_id     menu_name     position     content     visible
1     1         New Article       1     This is the first Picture and   Article     1
2     1         Edit Articles     2     Delete Articles/Edit 333

Answer 1

The * in your query means you'll select every colomn, just use the columnames you want to retrieve.

example:

SELECT id, position FROM pages ORDER BY position

That's all ;)