[SQL] Concat

SELECT * FROM `tmp` AS T1 ,  `pca_index` AS T2
WHERE T1.tchrom = T2.chrom AND
T2.gene_members like  concat("%",T1.tSYM,"%")

CONCAT(字串1, 字串2, 字串3, ...): 將字串1、字串2、字串3，等字串連在一起。