mysql LCASE() 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 LCASE() functionsyntax
Function: Convert the field value to lowercase.
Syntax: SELECT LCASE(column_name) FROM table_name
mysql LCASE() functionexample
//选取 "LastName" 和 "FirstName" 列的内容，然后把 "LastName" 列转换为小写 SELECT LCASE(LastName) as LastName,FirstName FROM Persons;