mysql UCASE() function


  Translation results:

case

英[keɪs]   美[kes]   

n. (actual) example, instance; situation, situation; litigation (event), case, Jurisprudence; container (box, box)

vt. Put... into a box (or box, etc.); cover it; surround, surround; [slang] (especially before theft) explore, investigate, Peep

Third person singular: cases Plural: cases Present participle: casing Past tense: cased Past participle: cased

mysql UCASE() functionsyntax

Function: Convert the field value to uppercase.

Syntax: SELECT UCASE(column_name) FROM table_name

mysql UCASE() functionexample

//选取 "LastName" 和 "FirstName" 列的内容,然后把 "LastName" 列转换为大写
SELECT UCASE(LastName) as LastName,FirstName FROM Persons;

Home

Videos

Q&A