MySQL – Replace, capitalization, concatenation, take a few bits, length

Substring (catName,1,1) // uppercase upper(substring(catName,1,1)) // lowercase Lower (subString (catName,1,length(catName))) // concatenate ("","","")  mysql> concat("a","b","===") mysql> a===b Concat (upper (substring (catName, 1, 1)), the lower (substring (catName, 1, length (catName))), "")Copy the code

Mysql > select concat(upper(substring(catName,1,1)),lower(substring(catName,1,length(catName))),"") from cat;Copy the code

replace

Mysql > select replace(catName,'a',' a') from cat;Copy the code