-- 正数时: 截取字符串中逗号',' 第一次出现左边的字符串
select SUBSTRING_INDEX(telephone,',', 1) as functionA from user
-- 负数时: 截取字符串中逗号',' 最后一次出现右边的字符串
select SUBSTRING_INDEX(telephone,',', -1) as functionA from user
-- telephone email
-- 去除字段右边空格
update user set telephone =rtrim(telephone);
-- 去除字段左边空格
update user set telephone =ltrim(telephone);
UPDATE device SET rfid = subString(dev_id,13)
-- 插入多条数据
INSERT into user_card_bind (id)
VALUES
(10051001),
(10051001),
(10051001),
SELECT email FROM user WHERE email is NULL
-- 查找字符出现的位置 从1开始
SELECT LOCATE('/',telephone) from user
-- 截取字符串 不包括'/'斜杠字符 要+1
SELECT subString(telephone,LOCATE('/',telephone)+1) from user
-- 更新数据
UPDATE user SET user_group_id = NULL WHERE user_group_id = 'mull'
-- 对数据进行分组
SELECT function_dep from user GROUP BY function_dep