sorting - MySQL: Order by field, placing empty cells at end -

i have mysql table contains number of products. want sort table 1 particular column (most of values begin numbers example: 1st, 2nd), etc. however, since records not have value column, when try sort, table automatically puts empty rows first.

i looking way sort row ascending, insert blank records @ end of sorted records, if makes sense?

any gratefully received!

select * table order if(field = '' or field null,1,0),field