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,'english','german','french'),Linkname ASC > >Maybe you meant FIELD(language...?
Right. Thanks. > >>From the manual: > >Changes in release 3.20.17 >-------------------------- >[...] > * The `ELT()' function is renamed to `FIELD()'. The new `ELT()' > function returns a value based on an index: `FIELD()' is the > inverse of `ELT()' Example: `ELT(2,"A","B","C")' returns `"B"'. > `FIELD("B","A","B","C")' returns `2'. > >The language column is a string containing 'english', 'french' or 'german'. > >The order of the fields in the FIELD() should be the order of what you want >as a result: 'french','german','english' will give you 'french' items >first, 'english' items last. Beware that any item with a language not >existing in the field list will get a zero value, and be sorted first. > >-- >Roger >query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php