Using function with result from subquery
mysql> mysql> SELECT NUMBER, POWER(NUMBER,3) -> FROM (SELECT 10 AS NUMBER UNION SELECT 11 UNION SELECT 12 -> UNION -> SELECT 13 UNION SELECT 14 UNION SELECT 15 -> UNION -> SELECT 16 UNION SELECT 17 UNION SELECT 18 -> UNION -> SELECT 19) AS NUMBERS -> WHERE POWER(NUMBER,3) <= 4000; +--------+-----------------+ | NUMBER | POWER(NUMBER,3) | +--------+-----------------+ | 10 | 1000 | | 11 | 1331 | | 12 | 1728 | | 13 | 2197 | | 14 | 2744 | | 15 | 3375 | +--------+-----------------+ 6 rows in set (0.00 sec) mysql>