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

Reply via email to