MySQL Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'calne.products.DISPLAY_NAME' which is not in SELECT list; this is incompatible with DISTINCT
Query:SELECT DISTINCT LEFT(DISPLAY_NAME, 1) as name FROM products ORDER BY DISPLAY_NAME