sql拼接字符串

mysql

CONCAT('doc/', dti.id, '/', dmi.id) AS href
AND CONCAT(',', tag, ',') LIKE '%,1,%'


sql server

AND ','+tag+',' LIKE '%,1,%'