Raychu150 Raychu150 -4 years ago 121
MySQL Question

Uppercase a specific column in multy table SELECT (MySQL)

I'm trying to show a specific column all in uppercase, but I canĀ“t do while selecting multiples tables. Thanks for your help.

table_1

id - name - last_name

table_2

id - person_id - amount

SELECT * FROM table_1, table_2, UPPER(table_1.name) WHERE table_1.id = table_2.person_id

Answer Source

The selected columns go first (that tables)

SELECT table_1.*, table_2.*, UPPER(table_1.name) as nameUpper FROM table_1, table_2 WHERE table_1.id = table_2.person_id
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download