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 order.
>
>SELECT * FROM links WHERE Accepter LIKE 1 AND CatID LIKE 43 ORDER BY
>language DESC,Linkname ASC;
>
>And for english selection I make this.
>SELECT * FROM links WHERE Accepter LIKE 1 AND CatID LIKE 43 ORDER BY
>language ASC,Linkname ASC;
>
>If I like to introduce german by example, what kind of query i have to do to
>put french links on top
>asc->english
>desc->german.
>french ?
>
>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
>Thanks.
>
>
>query sql mysql
