Tags
MySQL , UPPER
Asked 2 years ago
31 May 2022
Views 806
QuickIos

QuickIos posted

how to use function UPPER in MySQL?

how to use UPPER in MySQL ? can you please explain function UPPER in MySQL with some example?
web-api

web-api
answered May 31 '22 00:00

The UPPER function converts a given string or character to upper case( lower case to upper case ) and the UPPER function works with static string and given string field as well.

select upper(`name`) from _categories


above query returns Upper case all field of `name` from the _categories table

select upper('static')


above query returns "STATIC"(upper case of 'static')
Edit Answer
eclipse-learner

eclipse-learner
answered May 31 '22 00:00

The UCASE function and the UPPER function both give the same result, The UCASE function and the UPPER function convert string so lower case to upper case.

select ucase('ArrayoverFlow')=upper('arrayoverflow')

it will return 1 (true) because UCASE function and UPPER function both do same job.
Edit Answer
Post Answer
OMG!   You need to Login / Register to Post Answer
[code] Bold LE LP LD LW LDR WAR INF DAN SUC FYI h2 h3 italic