1.1 字符串轉(zhuǎn)對應(yīng)的名稱
一串用戶id字符串(逗號分割)吭产，需要轉(zhuǎn)成對應(yīng)的用戶昵稱
-- view_members 用戶id集合（uid1,uid1,uid3）
-- view_member_names 用戶昵稱集合（uname1,uname1,uname3）
select
tb.*,
(select group_concat(tu.name) from t_user tu where find_in_set(tu.id,t.view_members)) as view_member_names
from t_bussiness tb
1.2 往前推15天
-- 方式1
select
date_sub(CURRENT_DATE, interval (@start_rn:=@start_rn +1)+1 day) startDate,
date_sub(CURRENT_DATE, interval (@end_rn:=@end_rn+1) day) endDate
from (select 1 from mysql.help_topic) a,(select @start_rn:=0,@end_rn:=0) b limit 15
-- 方式2
select
@start_rn,
date_sub(str_to_date('2022-05-10','%Y-%m-%d') , interval (@start_rn:=@start_rn +1)-1 day) startDate
from (select 1 from mysql.help_topic) a,(select @start_rn:=0) b
where @start_rn<=datediff(str_to_date('2022-05-10','%Y-%m-%d'),str_to_date('2022-05-01','%Y-%m-%d'))
image.png
