mysql函数

select ascii('C'),ascii('c'); --查看C和c的ASCII码
+------------+------------+
| ascii('C') | ascii('c') |
+------------+------------+
|         67 |         99 |
+------------+------------+

select concat_ws('.',s_name,s_sex,s_birth) from student;（先打分隔符，再打列或字符串）

孙风.男.1990-05-20                  

select find_in_set("c","a,b,c,d,e");--查看c在abcde中的位置

 select insert("aSSSSSSSSS",1,5,"cccccccccccc"); --将aSSSSSSSSS从第一个到第五个替换为cccccccccccc
+-----------------------------------------+
| insert("aSSSSSSSSS",1,5,"cccccccccccc") |
+-----------------------------------------+
| ccccccccccccSSSSS                       |
+-----------------------------------------+

SELECT FORMAT(250500.5634, 2);--将数字格式化保留到小数点第2位
+------------------------+
| FORMAT(250500.5634, 2) |
+------------------------+
| 250,500.56             |
+------------------------+

SELECT CHAR_LENGTH("RUNOOB") AS LengthOfString;-- 查runoob所占字符数。
+----------------+
| LengthOfString |
+----------------+
|              6 |
+----------------+

SELECT CONCAT("SQL ", "Runoob ", "Gooogle ", "Facebook");--将sql,runoob,gooogle合并为一个表。
+---------------------------------------------------+
| CONCAT("SQL ", "Runoob ", "Gooogle ", "Facebook") |
+---------------------------------------------------+
| SQL Runoob Gooogle Facebook                       |
+---------------------------------------------------+

--获取 b 在字符串 abc 中的位置：
SELECT LOCATE('st','myteststring');
+-----------------------------+
| LOCATE('st','myteststring') |
+-----------------------------+
|                           5 |
+-----------------------------+

 SELECT LCASE ('WXCCC');--将大写改为小写
+-----------------+
| LCASE ('WXCCC') |
+-----------------+
| wxccc           |
+-----------------+

select left ('ccccccc',3);--将ccccccc中前三个取出
+--------------------+
| left ('ccccccc',3) |
+--------------------+
| ccc                |
+--------------------+

SELECT LTRIM("    RUNOOB");--将开始处空格取消。
+---------------------+
| LTRIM("    RUNOOB") |
+---------------------+
| RUNOOB              |
+---------------------+

SELECT MID("RUNOOB", 2, 3) AS ExtractString;--从字符串 RUNOOB 中的第 2 个位置截取 3个 字符：
+---------------+
| ExtractString |
+---------------+
| UNO           |
+---------------+

SELECT POSITION('a' in 'abc');--a在abc中的位置
+------------------------+
| POSITION('a' in 'abc') |
+------------------------+
|                      1 |
+------------------------+

SELECT REPEAT('a',3);--将a重复三次
+---------------+
| REPEAT('a',3) |
+---------------+
| aaa           |
+---------------+

SELECT REPLACE('abc','a','d');--将a换成d
+------------------------+
| REPLACE('abc','a','d') |
+------------------------+
| dbc                    |
+------------------------+

SELECT RIGHT('run',1);--返回字符串 run 的后1个字符：
+----------------+
| RIGHT('run',1) |
+----------------+
| n              |
+----------------+

SELECT RPAD('abc',5,'ff');--将字符串 ff 填充到 abc 字符串的结尾处
+--------------------+
| RPAD('abc',5,'ff') |
+--------------------+
| abcff              |
+--------------------+

SELECT RTRIM("RUN     ") AS RightTrimmedString; --去掉字符串 RUN 的末尾空格： 
+--------------------+
| RightTrimmedString |
+--------------------+
| RUN                |
+--------------------+

SELECT SPACE(1);--返回 1个空格：
+----------+
| SPACE(1) |
+----------+
|          |
+----------+

SELECT UPPER("run");--变为大写
+--------------+
| UPPER("run") |
+--------------+
| RUN          |
+--------------+

SELECT TRIM('    RUNOOB    ')；--去除前后空格
+------------------------+
| TRIM('    RUNOOB    ') |
+------------------------+
| RUNOOB                 |
+------------------------+