MySQL order multiple directions using FIND_IN_SET
I have a query that orders by FIND_IN_SET and then a secondary ORDER field...date_added.

What I am wanting to now do is something like:

    ORDER BY FIND_IN_SET(status, '1,2,3), date_added ASC
    AND
    ORDER BY FIND_IN_SET(status, '4,5'), end_date DESC

so I want to order status 1,2 and 3 by date_added ASC and the status 4 and 5 by end_date DESC.

Can this be done using a single query?
MySQL order multiple directions using FIND_IN_SET
===

I have a query that orders by FIND_IN_SET and then a secondary ORDER field...date_added.

What I am wanting to now do is something like:

    ORDER BY FIND_IN_SET(status, '1,2,3), date_added ASC
    AND
    ORDER BY FIND_IN_SET(status, '4,5'), end_date DESC

so I want to order status 1,2 and 3 by date_added ASC and the status 4 and 5 by end_date DESC.

Can this be done using a single query?