mysql随笔

SELECt a.id,GROUP_CONCAT(b.name)
from t_customer as a left join t_region as b on FIND_IN_SET(b.id,a.need_address) group by a.id

 

update t_customer as a ,t_a as b
set a.need_address_info = b.`name` where a.id = b.id