lundi 1 août 2016

Sort MySQL Select in two ways without ORDER BY

Here is the problem: I want my data sorted in 2 differents way without calling two times the database.

Example:

SELECT data FROM costumers WHERE x ORDER BY budget, car, home

I need this data sorted in this way to do fast some operations.

In the meantime I need also the same data but:

ORDER BY home, budget, car

I can reorder the data in php or make a second query to my database but I hope there is a simplee and faster way to make it works with MySql. (maybe the data could be fetch in two differents ways)

Thanks in advance :)

(first time I post, but not first time this website helps me)

Aucun commentaire:

Enregistrer un commentaire