select a fictional column

[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

[a.stilliard]

You can select something as something else, so you could select the word 'luck' as f5

 

SELECT f1, f2, 'luck' AS f5 FROM tablename

[James25]

hmm, it didn't work in my case

[fenway]

hmm, it didn't work in my case

Show us the query.