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

Reply via email to