
SELECT lists.label, lists.value FROM ((SELECT "Item 1" AS label, 1 AS value) UNION (SELECT "Item 2" AS label, 2 AS value) UNION (SELECT "Item 3" AS label, 3 AS value)) AS lists ORDER BY lists.label ASC
+--------+-------+ | label | value | +--------+-------+ | Item 1 | 1 | | Item 2 | 2 | | Item 3 | 3 | +--------+-------+
Comments
No comments have been posted