mysql in 的另一种替换方法
摘要:select c.*,u.user_name as host_name ,uc.user_name as create_name,(select group_concat(case when real_name is null then user_name else real_name end) from user where INSTR(c.invite_user,concat(',',id,','))>0order by find_in_set(id,c.invite_user)) as invite from communicate c left j
阅读全文