Can you 'sort by' and 'limit' your result to make mysql just return one row?

EDIT: That should have been 'order by', not 'sort by'.