MySQL select that returns a dummy column?

Question

Is there a way i can do a SELECT and tell it to return 3 columns and a dummy empty column ? I need 4 columns and the 3rd must be '' until the table is somewhere in the database. I am not allowed to add any columns to any tables.

Answer 1

Select column1, column2, 'waiting for table' as dummy_column, column4
from your_table

Answer 2

mysql> SELECT '' AS empty_col;
+-----------+
| empty_col |
+-----------+
|           |
+-----------+
1 row in set (0.00 sec)