Match fields between multiple tables in MySQL

"MySQL" Multi-table field matching 1 $ SQL = $ empire-> query ("select table. title, lianxi, table. dizhi, table. id from table, table1 where table1.sid like concat ('% |', table. id, '| %') and table1.id = ". $ navinfor [id]. ""); 2 while ($ r = $ empire-> fetch ($ SQL) 3 {4 $ title = $ r ['title']; 5 $ lianxi = $ r ['liance']; 6 $ dizhi = $ r ['dizhi']; 7} www.2cto.com: two tables info, tag info table id name 1 aa and bb 2 bb and cc 3 ee and dd www.2cto.com tag Table 1 aa 2 bb tag table name matches the name in info, so there is a problem: select info. id, info. name from tag, info where info. name like '%' + tag. name + '%' correct: select info. id, info. name from tag, info where info. name like concat ('%', tag. name, '%') origin: http://explife.cnblogs.com