Order results in specific order

[The Little Guy]

I have this query:

 

SELECT * FROM docs WHERE (`title` = 'Person' OR `type` = 'method' OR `type` = 'property' OR `type` = 'example') AND `class` = 'Person' ORDER BY `type` ('class', 'property', 'method', 'example'), `title`

 

I was hoping that it would work, but it doesn't.

 

What I was hoping what would happen is that my order by `type` would be ordered in the following order:

'class', 'property', 'method', 'example'

 

But that didn't work. So. How can I order my results in that exact order? The column type for `type` is ENUM, and the values for it are: 'class', 'property', 'method', 'example'.

 

So how can I do that?

[The Little Guy]

Got it!

 

SELECT * FROM docs WHERE (`title` = '$title') OR (`type` = 'method' OR `type` = 'property' OR `type` = 'example') AND `class` = '$title' ORDER BY FIELD(`type`, 'class', 'property', 'method', 'example'), `title`