mysql empty row at end of ASC rather than beginning

[coldwerturkey]

I have a query retrieving a list ASC by the name/title, so alphabetical.

I need the blank name/titles to show at the end of the a-z list rather than the beginning

I can do this with php, but it seems like something I should learn in mysql, can anyone please lend a hand?

SELECT title FROM table ORDER BY title ASC

[bradgrafelman]

One way would be to use a CASE:

SELECT title
FROM table
ORDER BY
  CASE WHEN title IS NULL THEN 1 ELSE 0 END ASC,
  title ASC