Select Something + An arbitrary Number in Mysql

Question

I have a situation where I need to do something like

select 2, id from users;

I think that would work at least with Oracle but it doesn't work in Mysql. Any ideas?

Answer 1

I think you'll need to assign a name for your arbitrary value:

SELECT 2 AS arbitrary_value, id FROM users;

Answer 2

your request is ok. Maybe you sould define more precisely "Doesn't work".