Converting values from a column to UPPERCASE

Navigation
3

Using MySQL commands, could you convert all values of a column to UPPERCASE ?

    
asked by anonymous 07.03.2017 / 18:28

1 answer

7

Use UPPER()

SELECT : 

SELECT UPPER(campo) FROM 'tabela'

UPDATE : 

UPDATE tabela SET campo = UPPER(campo)
    
07.03.2017 / 18:53
Problem sending model to controller How to tell if a key in the sql server is identity