Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • UPPER(str) mysql function

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 449
    Comment on it

    UPPER(str)

    UPPER() function returns the string str with all characters changed to uppercase according to the current character set mapping means if you want to get a string with all character in upper case then you can use this function.

    Here is some example related to this-

    mysql> SELECT UPPER('Hello mysql.');
    +-----------------------+
    | UPPER('Hello mysql.') |
    +-----------------------+
    | HELLO MYSQL.          |
    +-----------------------+
    1 row in set (0.00 sec)
    
    mysql>  SET @str = BINARY 'Hello mysql';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> SELECT UPPER(@str), UPPER(CONVERT(@str USING latin1));
    +-------------+-----------------------------------+
    | UPPER(@str) | UPPER(CONVERT(@str USING latin1)) |
    +-------------+-----------------------------------+
    | Hello mysql | HELLO MYSQL                       |
    +-------------+-----------------------------------+
    1 row in set (0.00 sec)
    

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: