架构师大咖
架构师大咖,打造有价值的架构师交流平台。分享架构师干货、教程、课程、资讯。架构师大咖,每日推送。
公众号该公众号已被封禁抓紧get新技能吧~MySQL常用字符串函数大写转小写 lower()mysql> select lower("KFDSKGS");+------------------+| lower("KFDSKGS") |+------------------+| kfdskgs |+------------------+小写转大写 upper()mysql> select upper("fdssssssss");+-------------------+| upper("fdssssssss") |+-------------------+| FDSSSSSSSS |+-------------------+字符串的连接 concat()mysql> select concat("My","S","QL");+--------------------+| concat("My","S","QL") |+--------------------+| MySQL |+--------------------+截取字符串 substr() / substring()mysql> select substring("Hello world",5);+-----------------------+| substring("Hello world",5) |+-----------------------
………………………………