title: MYSQL order by - NULL values impacting my results
body: <p>A table of about 200 rows, 15 of which will have a numeric value rankClass (1-15). The rest will have NULL values.</p>
  <p><code>ORDER BY rankClass, nameLast</code></p>
  <p>It posts the rows with NULL values first, and when I add DESC, of course, it lists it set rows first, but 15-1.  I'd like it to list those with values first, 1-15, then the rest by nameLast.</p>
  <p>I've tried coalesce, but it goes 1,10,11,12,13,14,15,2,3,4,5,6,7,8,9.</p>
  <p>How would I get the results I'm looking for?</p>