mysql判断排序标准,在mysql中按某些标准排序

I need to be able to order my output data in a proper way using MySQL.

I'm using ORDER BY so far and everything was working correctly until now.

Let's say I have something like this:

Table VEHICLES:

ID | Name | MainGroup | SubGroup

1 | A | Vehicle | Truck

2 | B | Vehicle | Car

3 | C | Vehicle | Car

4 | D | Vehicle | Truck

5 | E | Vehicle | Truck

6 | F | Vehicle | Motorbike

I was using this:

SELECT * FROM Vehicles WHERE MainGroup=Vehicle ORDER BY Subgroup;

When I get selections they are not sorted in a way that I want, because now I want to be able to determine the way of the selected ones. Let's say that I want an output like this Car, Truck, Motorbike or some other way around. How to achieve this?

Is this doable using an order by?

解决方案

Use field():

SELECT *

FROM Vehicles

WHERE MainGroup=Vehicle

ORDER BY field(Subgroup, 'Car', 'Truck', 'Motorbike');