Mysql 将多个字段拼成一个字段,. concat, concat_ws, group_concat, repeat

concat(参数1, 参数2, 参数3...)

select CONCAT(TITLE, DESCRIPTION) from t_video;
select CONCAT(TITLE, DESCRIPTION, TAGS) from t_video    # 如果tags为Null, 则返回Null

concat_ws(连接符, 参数1, 参数2...)

select ID, CONCAT_WS('-', TITLE, DESCRIPTION)  from t_video;   --title和description字段合并,用'-'连接

group_concat(参数1 )

-- 某个字段多行合一行
select TAGS, group_concat(TITLE)  from t_video group by TAGS;        

-- 两个字段合并为一行
select TAGS, group_concat(TITLE, DESCRIPTION)  from t_video group by TAGS;   

-- 去重,排序, 按"="分隔(默认是',')
select TAGS, group_concat( DISTINCT TITLE ORDER BY seq  SEPARATOR "=")  from t_video group by TAGS;    

repeat(参数1, 复制次数)

--title复制两次
SELECT REPEAT(TITLE,2) from t_video