mysql 多个等于 顺序_MySQL选择多个顺序

所以我得到了这张桌子：

+----+---------------------+-----+----------------+

| ID | WHEN | OFF | (other..stuff) |

+----+---------------------+-----+----------------+

| 1 | 2012-09-17 17:00:00 | 0 | anything1 |

| 2 | 2012-09-17 18:00:00 | 0 | anything2 |

| 3 | 2012-08-31 21:00:00 | 1 | blabla321 |

| 4 | 2012-08-31 18:30:00 | 1 | blab32121 |

+----+---------------------+-----+----------------+

我想选择所有键但是：

> off = 0的键应该在ASC时排序,它们应该是

首先显示

> off = 1的键应该在DESC时按顺序排列,它们应该是

显示之后(结尾)

我试过这样的事情：

(SELECT * FROM `table` WHERE `off` = 0 ORDER BY `when` ASC)

UNION

(SELECT * FROM `table` WHERE `off` = 1 ORDER BY `when` DESC)

但它不起作用.