What I'd like to do is order my query so that the results show every row found, but are ordered by showing results that begin with the letter 'D' first. Is this something that is possible to do with ORDER BY? I know I can use WHERE field LIKE 'D%', but I'd like all the results not just those with D.
My query currently looks as follows:
SELECT pname, pdescription, price FROM products WHERE manufacturer = 3 ORDER BY pname ASC
Best Answer
Have a look at below example