Help me to create a good MySQL Query

notset

Hello,

i have mysql table orders with field status = enum('inactive', 'active', 'expired', 'suspended');

I need to display results sorting by status.

The simpliest way would be to make 4 queries with selecting different status value. But maybe i could get the same result with only one mysql query?

Thank you.

bradgrafelman

SELECT `column1`, `column2`, `status`
FROM `myTable`
GROUP BY `status`

notset

But with "GROUP BY" i get only 1 result with every status value...

bradgrafelman

Woops, I meant "ORDER BY" (I had just been reading a thread dealing with grouping :p).

mroden

notset wrote:
Hello,

i have mysql table orders with field status = enum('inactive', 'active', 'expired', 'suspended');

I need to display results sorting by status.

The simpliest way would be to make 4 queries with selecting different status value. But maybe i could get the same result with only one mysql query?

Thank you.

if you want to sort alphabetically by the status values, you can alter the table to have the enum values in alphabetical order.

else using order by status will sort in the numerical order as they appear in the create table statement 'inactive'=1, 'active'=2, 'expired'=3, 'suspended'=4

Make sense?