Mysql Multiple table field matching implementation code _MYSQL

Copy Code code 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 [' Lianxi '];
$dizhi = $r [' Dizhi '];
}

As follows: Two table Info,tag
Info table
ID Name
1 AA and BB
2 BB and CC
3 EE and DD
Tag table
1 AA
2 BB
Name in tag table name match info
There is a problem with this writing:

Copy Code code as follows:

Select Info.id, info.name from Tag,info where info.name like '% ' +tag.name+ '% '

That's right:

Copy Code code as follows:

Select Info.id, info.name from Tag,info where info.name like concat ('% ', tag.name, '% ')