concat_ws, spilt, sort_array,size

最新推荐文章于 2023-03-30 11:42:55 发布

云溪*

最新推荐文章于 2023-03-30 11:42:55 发布

阅读量697

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/Marybabana/article/details/94748325

版权

mysql 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

这三个字段，通过各个函数结果

concat_ws

用相应符号将各字段连接起来 string类型

select concat_ws(',',user_id,mobile,system) as concat
from statistic.qz_track
limit 5;


concat
"13742988,,android"
"38643821,+8613075351265,android"
"11230781,,android"
"38702379,,android"
"0,+8613414655611,android"

spilt

将上述结果通过spilt ，分开

select split(concat_ws(",",user_id,mobile,system), ",")  con_sp
from statistic.qz_track
limit 5;


con_sp
"[""13742988"","""",""android""]"
"[""38643821"",""+8613075351265"",""android""]"
"[""11230781"","""",""android""]"
"[""38702379"","""",""android""]"
"[""0"",""+8613414655611"",""android""]"

sort_array 默认升序

select sort_array(split(concat_ws(",",user_id,mobile,system), ",")) as con_sa
from statistic.qz_track
limit 5;

con_sa
"["""",""13742988"",""android""]"
"[""+8613075351265"",""38643821"",""android""]"
"["""",""11230781"",""android""]"
"["""",""38702379"",""android""]"
"[""+8613414655611"",""0"",""android""]"