MariaDB 10.2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();


VERSION()


10.2.6-MariaDB-10.2.6+maria~jessie-log


DROP TABLE IF EXISTS `GEAR`;
CREATE TABLE IF NOT EXISTS `GEAR` (
  `stat` INT UNSIGNED NOT NULL,
  `quality` VARCHAR(7) NOT NULL
);
INSERT INTO `GEAR`
  (`stat`, `quality`)
VALUES
  (1, 'normal'),
  (11, 'normal'),
  (12, 'better'),
  (2, 'better');
SET @`bool` := FALSE;
PREPARE `stmt` FROM CONCAT('
SELECT `stat`, `quality`
FROM `GEAR`
ORDER BY ',
  CASE
    WHEN TRUE = @`bool` THEN '`stat`'
    WHEN FALSE = @`bool` THEN '`quality`'
  END,
' DESC');
EXECUTE `stmt`;


stat
quality


1
normal

11
normal

12
better

2
better


SET @`bool` := TRUE;
PREPARE `stmt` FROM CONCAT('
SELECT `stat`, `quality`
FROM `GEAR`
ORDER BY ',
  CASE
    WHEN TRUE = @`bool` THEN '`stat`'
    WHEN FALSE = @`bool` THEN '`quality`'
  END,
' DESC');
EXECUTE `stmt`;


stat
quality


12
better

11
normal

2
better

1
normal


DEALLOCATE PREPARE `stmt`;