[SOLVED] Order By Data

[jaymc]

Lets say I have a field which contains the following entries, as enum for example

 

Beans

Lettuce

Chocolate

Onion

Milk

 

I want to order by Beans, Milk, Onion, Chocolate, Lettuce

 

So not ASC or DESC, an order which is defined by data I input as shown above

[Maq]

SELECT * FROM table ORDER BY FIELD(field_name, 'Beans', 'Lettuce', 'Chocolate', 'Onion', 'Milk') DESC;

[jaymc]

Hmm that didn't appear to work. It just orders the data by DESC ignoring my defined order

 

Heres the query

 

SELECT `First Name`, `Mobile Phone`, `ID/Status` idstat FROM `example_innodb`
	GROUP BY `Mobile Phone`
	ORDER BY FIELD(`ID/Status`, 'Hot Prospect', 'Prospect', 'Be Back', 'Blow Out') DESC

 

 

[Maq]

Take out DESC.

[jaymc]

Worked