How do I order rows in a specific sequence using MySQL?

Question

I have a query like this:

SELECT BookSize(page_count) as Size, count(*) as NmbrBoooks 
    FROM books 
    WHERE page_count IS NOT NULL 
        AND page_count > 0 
    GROUP BY Size;

The output is as follows:

+-----------+------------+
| Size      | NmbrBoooks |
+-----------+------------+
| ExtraLong |          3 |
| Long      |         11 |
| Medium    |         51 |
| Short     |         27 |
+-----------+------------+

I would like to sort this according to the book's length so I have the following row sequence from top to bottom: Short, Medium, Long, ExtraLong.

What is the best way to achieve this?

Alex · Accepted Answer · 2014-04-30 04:27:08Z

1

Try this:

select BookSize(page_count) as Size, count(*) as NmbrBoooks from books
where page_count is not null and page_count > 0 group by Size order by page_count;

answered Apr 30, 2014 at 4:27

Alex

11.6k7 gold badges39 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I order rows in a specific sequence using MySQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related