displaying empty strings last when using order by

[davidklonski]

Hello

I would like to be able to display the content of a table sorted alphabetically (ascending) by 'name' (one of the columns) with the following little twist:
all the rows which have an empty name column should be displayed last. The rest of the rows should be displayed before them with regular ascending alphabetical order.

I also have the requirement that I must use limit x,y on the query so I will not extract the entire table.

how can I combine all these requirements into a single query?

[dopey]

This should do it...

select 
	* 
from 
	myTable
order by 
	name = '' ASC, name ASC
limit
                1,10