title: MySQL: Order by field, placing empty cells at end
body: <p>I have a MySQL table which contains a number of products. What I want to do is sort the table by one particular column (most of the values begin with numbers for example: 1st, 2nd), etc. However, since some records do not have a value for this column, when I try to sort, the table automatically puts empty rows FIRST. </p>
  
  <p>I am looking for a way to sort the row ASCENDING, but only insert blank records at the end of the sorted records, if that makes sense?</p>
  
  <p>Any help would be most gratefully received!</p>