RE: mysql and order in a query

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 ELT(language,'engl

Re: mysql and order in a query

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 w

RE: mysql and order in a query

* 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

Re: mysql and order in a query

At 18:03 +0200 4/6/02, David yahoo wrote: >Hi all, > >I d like to order some links which are in 2 langauage (French/English). > >So i make this request in case a visitor select french in language so french >links where on top in this case >because "f"rench is after "e"nglish in alphabectical orde