RE: mysql and order in a query

2002-04-06 Thread Roger Baklund
* Paul DuBois At 18:03 +0200 4/6/02, David yahoo wrote: Is there any way to put a sort order different than the alpahbetical order in string. A thing like that order french,german ORDER BY ELT(language,'english','german','french'),Linkname ASC Maybe you meant FIELD(language...?

Re: mysql and order in a query

2002-04-06 Thread David yahoo
I think of a little hack I can add in where clause something like : ELT(language,'english','german','french') != 0 to avoid language not in list even if there no normally :) I try this as soon as i can. thanks. * Paul DuBois At 18:03 +0200 4/6/02, David yahoo wrote: Is there any way to

RE: mysql and order in a query

2002-04-06 Thread Paul DuBois
At 18:28 +0200 4/6/02, Roger Baklund wrote: * Paul DuBois At 18:03 +0200 4/6/02, David yahoo wrote: Is there any way to put a sort order different than the alpahbetical order in string. A thing like that order french,german ORDER BY