Q:

Mysql Order by Starting letter

I need to sort[order by] the query based on starting letter.
Ex.,
      there will be a title column.
I need to sort based on letter 'e'.
The result needed is , the fields starting with letter 'e' should come first and the rest of the result should come afterwards.

A:

...ORDER BY CASE WHEN LEFT(title, 1) = 'e' THEN 1 ELSE 2 END,
            title

