ISNULL 函数:判断是否为NULL,是则返回1,否则返回0
SELECT ISNULL(`commission_pct`),`commission_pct` FROM employees
ORDER BY 多字段排序
SELECT * FROM employees ORDER BY salary DESC,`employee_id`
UPPER()转大写、LOWER()转小写、CONCAT()拼接字符、LENGTH()返回字节长度
SELECT CONCAT(UPPER(last_name),'_',LOWER(`first_name`)) AS 姓名,LENGTH(last_name) AS 长度 FROM employees
SUBSTR(str,起始索引,截取长度)
SELECT CONCAT(UPPER(SUBSTR(`last_name`,1,1)),LOWER(SUBSTR(`last_name`,2))) AS 姓名 FROM employees
INSTR()
SELECT INSTR('abcdefgdefdswde','de') AS 第一次出现的索引
TRIM()
SELECT TRIM('a' FROM 'aaaaaaaaaaaaaaaGZNaaaaaaaaaaaaaaaaa') AS 过滤前后指定字符
LPAD()、RPAD()
SELECT LPAD('ABC',10,'*') AS 左填充指定字符
SELECT LPAD('ABCD',2,'*') AS 返回填充长度的字符
SELECT RPAD('ABC',10,'*') AS 右填充指定字符
REPLACE(str,指定字符,替换字符)指定字符替换
SELECT REPLACE('askfjslkdfklwsdjsjsask','s','--') AS 替换字符