mysql合并字符串(sql地址合并)

在这里插入图片描述在这里插入图片描述
未合并前sql:

SELECT
	ent.*,
	province.districtname AS addressprovinceName,
	city.districtname AS addresscityName,
	county.districtname AS addresscountyName 
FROM
	customer_enterprise ent
	LEFT JOIN base_districtinfo province ON province.id = ent.addressprovince
	LEFT JOIN base_districtinfo city ON city.id = ent.addresscity
	LEFT JOIN base_districtinfo county ON county.id = ent.addresscounty

结果sql:

SELECT
	ent.*,
	CONCAT(province.districtname,'—',city.districtname,'—',county.districtname) address
FROM
	customer_enterprise ent
	LEFT JOIN base_districtinfo province ON province.id = ent.addressprovince
	LEFT JOIN base_districtinfo city ON city.id = ent.addresscity
	LEFT JOIN base_districtinfo county ON county.id = ent.addresscounty
版权声明：本文为qq_41906761原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。