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 LCASE() function syntax

Function:Convert the field value to lowercase.

Syntax:SELECT LCASE(column_name) FROM table_name

mysql LCASE() function example

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