Code for matching fields between multiple MySQL tables

CopyCodeThe Code is as follows: $ 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]. "");
While ($ r = $ empire-> fetch ($ SQL ))
{
$ Title = $ R ['title'];
$ Lianxi = $ R ['liance'];
$ Dizhi = $ R ['dizhi'];
}

The two tables info and tag are as follows:
Info table
ID name
1 aa and BB
2 BB and CC
3 EE and dd
Tag table
1 aa
2 bb
The name in the tag table matches the name in info.
In this case, there is a problem:Copy codeThe Code is as follows: Select info. ID, info. name from tag, info where info. name like '%' + tag. Name + '%'

Correct:Copy codeThe Code is as follows: Select info. ID, info. name from tag, info where info. name like Concat ('%', tag. Name, '% ')