MySQL select with min

Question

I need to select fields message and username from table list where list_id=1 (it can be 2 or 5 etc) with minimal number value (min(number)). How can i do it? I tried it:

SELECT `message`,`username` FROM `list` WHERE `list_id`=2 AND min(`number`)

But it not work.

Answer 1

Try so

SELECT `message`,`username`
FROM `list`
WHERE `list_id` = 2
ORDER BY `number` ASC
LIMIT 1