CODEWITHSUNDEEP
mysql
Sasireka Ganesan
Sasireka Ganesan

Reputation: 15

MySQL result set

Consider there is a table called employee in MySQL database.

If I use "select firstname from employee;"

The output will be

firstname

xyz
abv
asd
asdf

If I use "select FIRSTNAME from employee;"

The output will be

FIRSTNAME

xyz
abv
asd
asdf

But i need name of the attribute should be display in uppercase in the result of this query.

how to do it in wamp server?

Upvotes: 0

Views: 32

Answers (1)

Samir Selia
Samir Selia

Reputation: 7065

Use Mysql UPPER to convert names to upper case

SELECT UPPER(name) AS FIRSTNAME

Upvotes: 1

Related Questions