select colname
from tablename
where (where clause)
order by b,a,c
This is all in the manual. If you have a search on the internet, you should
be able to find a manual in chinese, if you haven't already got one. I know
there is one in traditional chinese, but I'm sure there is one for
simplified as well.
----- Original Message -----
From: "eboys_lsq" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 11:36
Subject: Help me to write a sql,please :)
> I want to write a sql to order by a column, whe column contain only
three type "a", "b", "c",
> how can I order by the column with the sequence of b,a,c . thank you.
> My english is not well ,sorry.,. :)
>
>
> Best Regards
> LSQ
>
> TEL:13500011809
> Company:020-83881512-223
> E-mail£º[EMAIL PROTECTED]
> HomeSite:http://www.eed2000.com
---------------------------------------------------------------------
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