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 --------------------------------------------------------------------- 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
