mysql查询某字段相同的记录

select * from 表名 where match_id in (select match_id from 表名 where team_id='a' or team_id='b' group by match_id)

表之间有关联关系吗，有的话 就 join 啊，查询的时候 每张表做不同的别名,比如a,b,c查询的时候就 select a.age, b.age,c.age from table1 as a join table2 as b on a.xxx=b.xxxjoin table3 as c on a.xxx=c.xxxwhere xxxxxx

select a.colunm_name,b.column_name from table_name1 a,table_name2 b where a.title like '%$content%' and a.colum_name=b.column_name

以此类推吧...按你自己的需求...

---