special order

[dan orlic]

Ok, I have a client that has a specific request.  the ordering of data.
For example current the order by returns this:

id | Name
----------
1  | #124
2  | #125
3  | #155
4  | apples
5  | bacon

but he would rather see the data as :

id | Name
----------
1  | apples
2  | bacon
3  | #124
4  | #125
5  | #155

how would I contruct that query?  many thanks...

dan