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
