Mysql ORDER BY help

LiamBailey

Hi Guys,

Long time no see.

I have a simple question can you order database results on 2 fields.

I want to order my results by Category, but I also want the newest articles to be at the top, i.e. in descending order by id or date, can this be achieved, or is the default to order results last-to-first which would save any hassle.

Piranha

You can't trust that the database will do any particular ordering by itself.

I don't follow how you want to order, but the query below will order by category, and the rows within the same category gets ordered by id.

select something from table order by categoryid, id

LiamBailey

Thanks Pirhana, that really helped.

foyer

you can also do this

ORDER BY column1 DESC, column2 ASC

Piranha

foyer;10900609 wrote:
you can also do this

ORDER BY column1 DESC, column2 ASC

If you use both DESC and ASC in the same query the indexes won't work, making the query slower than if you use DESC or ASC on both the columns. But it works.