MySQL常用函数汇总——字符串操作函数
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了MySQL常用函数汇总——字符串操作函数,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3590字,纯文字阅读大概需要6分钟。
内容图文
SELECT LENGTH(‘name‘),LENGTH(‘数据库‘); +----------------+---------------------+ |LENGTH(‘name‘) | LENGTH(‘数据库‘) | +----------------+---------------------+ | 4 | 9 | +----------------+---------------------+ 1 row in set (0.04 sec)
mysql> SELECT CONCAT(‘MySQL‘,‘5.7‘),CONCAT(‘MySQL‘,NULL); +-----------------------+----------------------+ | CONCAT(‘MySQL‘,‘5.7‘) | CONCAT(‘MySQL‘,NULL) | +-----------------------+----------------------+ | MySQL5.7 | NULL | +-----------------------+----------------------+ 1 row in set (0.03 sec)
mysql> SELECT INSERT(‘Football‘,2,4,‘Play‘) AS col1, -> INSERT(‘Football‘,-1,4,‘Play‘) AS col2, -> INSERT(‘Football‘,3,20,‘Play‘) AS col3; +----------+----------+--------+ | col1 | col2 | col3 | +----------+----------+--------+ | FPlayall | Football | FoPlay | +----------+----------+--------+ 1 row in set (0.04 sec)
mysql> SELECT LOWER(‘BLUE‘),LOWER(‘Blue‘); +---------------+---------------+ | LOWER(‘BLUE‘) | LOWER(‘Blue‘) | +---------------+---------------+ | blue | blue | +---------------+---------------+ 1 row in set (0.03 sec)
mysql> SELECT UPPER(‘green‘),UPPER(‘Green‘); +----------------+----------------+ | UPPER(‘green‘) | UPPER(‘Green‘) | +----------------+----------------+ | GREEN | GREEN | +----------------+----------------+ 1 row in set (0.03 sec)
mysql> SELECT LEFT(‘MySQL‘,2); +-----------------+ | LEFT(‘MySQL‘,2) | +-----------------+ | My | +-----------------+ 1 row in set (0.04 sec)
mysql> SELECT RIGHT(‘MySQL‘,3); +------------------+ | RIGHT(‘MySQL‘,3) | +------------------+ | SQL | +------------------+ 1 row in set (0.00 sec)
mysql> SELECT ‘[ mobile ]‘,CONCAT(‘[‘,TRIM(‘ mobile ‘),‘]‘); +----------------+--------------------------------------+ | [ mobile ] | CONCAT(‘[‘,TRIM(‘ mobile ‘),‘]‘) | +----------------+--------------------------------------+ | [ mobile ] | [mobile] | +----------------+--------------------------------------+ 1 row in set (0.07 sec)
mysql> SELECT REPLACE(‘aaa.mysql.com‘,‘a‘,‘w‘); +----------------------------------+ | REPLACE(‘aaa.mysql.com‘,‘a‘,‘w‘) | +----------------------------------+ | www.mysql.com | +----------------------------------+ 1 row in set (0.00 sec)
mysql> SELECT SUBSTRING(‘computer‘,3) AS col1, -> SUBSTRING(‘computer‘,3,4) AS col2, -> SUBSTRING(‘computer‘,-3) AS col3, -> SUBSTRING(‘computer‘,-5,3) AS col4; +--------+------+------+------+ | col1 | col2 | col3 | col4 | +--------+------+------+------+ | mputer | mput | ter | put | +--------+------+------+------+ 1 row in set (0.00 sec)
mysql> SELECT REVERSE(‘hello‘); +------------------+ | REVERSE(‘hello‘) | +------------------+ | olleh | +------------------+ 1 row in set (0.00 sec)
MySQL常用函数汇总——字符串操作函数
标签:字符串长度 div 转换 -- mysql常用函数 mob bst 返回结果 字符串操作
本文系统来源:https://www.cnblogs.com/XiaoMingBlingBling/p/12502526.html
内容总结
以上是互联网集市为您收集整理的MySQL常用函数汇总——字符串操作函数全部内容,希望文章能够帮你解决MySQL常用函数汇总——字符串操作函数所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。