SELECT * FROM motor_category ORDER BY ( CASE WHEN motor_category_name LIKE "Honda" THEN 0 WHEN motor_category_name LIKE "BMW" THEN 0 WHEN motor_category_name LIKE "KTM" THEN 0 WHEN motor_category_name LIKE "Kawasaki" THEN 0 WHEN motor_category_name LIKE "Suzuki" THEN 0 WHEN motor_category_name LIKE "Yamaha" THEN 0 WHEN motor_category_name LIKE "---------------------" THEN 1 ELSE 2 END ), motor_category_name ASC