How to select static values column?

mysql, select

Solution

Union is usually the quick way to create a defined set of values in a single data set

SELECT 1 as Value
UNION
SELECT 2 as Value
UNION
SELECT 3 as Value

If this is going to have lots of values, then building a tally/number table might be a more preferable method. Creating a "Numbers Table" in mysql

Problem

When we run query `SELECT 1` then MySQL returns one row with one column containing 1. How should I build the query to get one column with several rows containing specified values? I think it can be something like `SELECT VALUES(1,2,3) AS v`?

Original source