Page 1 of 1

select a fictional column

Posted: Fri Jun 11, 2010 4:53 am
by rupam_jaiswal
Hi,
In mysql, I have a table A with fields f1,f1,f3,f4.
I want to select some selected column values like f1,f2 and a new fictional column f5 whose value will always be 'luck'.
say it should return

f1 f2 f5
------------------
a1 a2 luck
b1 b2 luck
c1 c2 luck

Is there any way out??
Thanks in advance!!!!!!
Regards

Re: select a fictional column

Posted: Fri Jun 11, 2010 3:01 pm
by tr0gd0rr

Code: Select all

SELECT f1, f2, 'luck' AS f5