ORDER BY最小数字

I am trying to order by lowest however this sql term below order's by highest number

SELECT * FROM questions ORDER BY question_ref DESC LIMIT 1;

Any help would be appreciated

Use ASC instead of DESC:

SELECT * FROM questions ORDER BY question_ref ASC LIMIT 1;

Make it ASC: SELECT * FROM questions ORDER BY question_ref ASC LIMIT 1;

Or: SELECT MIN(question_ref) FROM questions;

SELECT * FROM questions ORDER BY question_ref ASC LIMIT 1;

Using ascending rather than descending ordering should do the trick: SELECT * FROM questions ORDER BY question_ref ASC LIMIT 1;