Sort products by image first and by name ASC I have a table with products, some products have images, some of them don’t. I have to sort these products by name ASC but first products should be these with an image (field isn’t empty string), and after that it should list the products without image, also name ASC. Thanks for help in advance!
Suggest an additional sorting column, imgsort, used as the first
criteria for the ORDER BY clause. Something along these lines: 

   SELECT 
       fields, ...
       , IF(image="",0,1) as `imgsort`
   FROM ...
   ORDER BY `imgsort` DESC, ...
   ;