Renaming columns generated in query

KidCudi · #1 (**permalink**) 01-16-11, 10:39

Hey guys just have a quick question,

Is it possible to change the column names generated by a mySql query ?.

For example I have a MIN(cost) and I want to rename the generated name "MIN(cost)" to say "Minimum Cost"

I hope I've worded that correctly so that you can understand, I apologise if I haven't.

Cheers

shammat · #2 (**permalink**) 01-16-11, 11:20

Code:

SELECT min(cos) as "Minimum Cost" 
FROM your_table

(Note that the usage of the double quotes requires MySQL to run in ANSI mode)

KidCudi · #3 (**permalink**) 01-16-11, 11:27

That's just what I was looking for, I searched the web but my searches where only giving me "alter" queries.

Thank you very much !

Internet Services

Web Development

Digital Marketing

Consumer Tech