MySQL 字符串连接函数

CONCAT(str1,str2,...)

可连接多个字符串

例:

SELECT * 
FROM `diag` AS t1,icd9_to_10 AS t2 
WHERE t1.DiagCode LIKE CONCAT(t2.icd9_code,'%');