id拼接保存到单个字段后作为表连接的查询条件

SELECT
	q.id,
	concat(q. NAME) qname,
	d.id did,
	d. NAME
FROM
	question_po q
LEFT JOIN data_configuration d ON q.NAME LIKE concat('%,', d.id, ',%');

 

 

 

 

 

转载于:https://www.cnblogs.com/LcxSummer/p/9431413.html