PREPARE `stmt` FROM CONCAT('
SELECT `stat`, `quality`
FROM `GEAR`
ORDER BY ',
CASE
WHEN TRUE = @`bool` THEN '`stat`'
WHEN FALSE = @`bool` THEN '`quality`'
END,
' DESC');
✓
hidden batch(es)
EXECUTE `stmt`;
stat
quality
1
normal
11
normal
12
better
2
better
…
hidden batch(es)
SET @`bool` := TRUE;
✓
hidden batch(es)
PREPARE `stmt` FROM CONCAT('
SELECT `stat`, `quality`
FROM `GEAR`
ORDER BY ',
CASE
WHEN TRUE = @`bool` THEN '`stat`'
WHEN FALSE = @`bool` THEN '`quality`'
END,
' DESC');
