如何才能查询出fromId或toId包含某个值，但fromId和toId不相互重复的数据？

Question

数据如下：

id     date         fromId      toId
--------------------------------------
 1     2013-01-01     1           2
 2     2013-01-02     2           1
 3     2013-01-03     1           3
 4     2013-01-04     3           1
 5     2013-01-05     4           1
 6     2013-01-06     1           4

 例如，查询fromId或toId包含1，去除fromId和toId中数据互换的列，仅取日期最大的值，查询结果为：

 id     date         fromId      toId
-------------------------------------- 2     2013-01-02     2           1 4     2013-01-04     3           1 6     2013-01-06     1           4

Answer 1

SELECT max(`date`),maxId,minId FROM (SELECT `date`,IF(fromId>toId,fromId,toId) AS maxId,IF(fromId>toId,toId,fromId) AS minId FROM `table`) AS `tmp` GROUP BY maxId,minId

Answer 2

select distinct fromId,* from table group by toId;