ORDER BY inputs

[erme]

How can I do something like this?

 

ORDER BY FieldName (name1,name2,name3)

 

Where name1,name2 etc is actual inputs in FieldName

[trq]

Sorry, that doesn't make allot of sense. Can you be a little more descriptive?

[erme]

Sorry, that doesn't make allot of sense. Can you be a little more descriptive?

 

 

I have a table with some values inside:

 

 

ID | Location

 

1  | Berlin

 

2  | Berlin

 

3  | London

 

4  | New York

 

5  | LA

 

 

 

I want to order by "New York" so the first result would be New York followed by the rest.

[trq]

SELECT ID, Location FROM tbl ORDER BY(Location, 'New York');

[erme]

Hmm, doesn't seem to work

[fenway]

I think thorpe meant:

 

SELECT ID, Location FROM tbl ORDER BY FIELD(Location, 'New York');

 

But careful if there are non-matching value.

[erme]

Perfect! Thank's guys.