substring_index(str,str1,a) 截取字符串
locate(substr,String)
weekday(now()) 周一为0,周日为6
adddate(NOW(),2) 后天
group_concat() 拼接分组数据,默认逗号分隔
date_format(now(),'%Y/%m/%d') 格式化日期
substr(str, a, b) 截取字符串 下标从1开始算,不是0,从a开始截取b个字符
trim()
ifnull(expression, alt_value))
CURDATE()
ip地址和整型之间转换,最大转化为255.255.255.255
mysql> select INET_ATON('192.168.88.123');
+-----------------------------+
| INET_ATON('192.168.88.123') |
+-----------------------------+
| 3232258171 |
+-----------------------------+
1 row in set (0.00 sec)
mysql> select INET_NTOA('3232258171');
+-------------------------+
| INET_NTOA('3232258171') |
+-------------------------+
| 192.168.88.123 |
+-------------------------+
1 row in set (0.00 sec)