MySQL field sort, what to do with

MySQL field sorting
In an SQL statement, if the field you want to sort is empty, how do you handle it if you want to put it in the back?

------Solution--------------------
If the field you want to sort is empty, the default is to put the empty row in front. Add a desc keyword can be in reverse order, that is, empty in the last side
------Solution--------------------
Suggest you post:
Create TABLE .....
Insert into Table ....

and expected results.
------Solution--------------------
ORDER by IsNull (' fields to sort by value ')
You can put the empty line in the back, you mean it?
------Solution--------------------
(... WHERE field name is not NULL GROUP by field name)

UNION (...) WHERE field name is NULL)

......
------Solution--------------------
... order by sort field = ' or sort field ID null, sort field
------Solution--------------------
Why the word blank Ah, build the table should try to be non-empty.

