MYSQL 单一表格 多次查询取交集和并集合

Question

 select * from info where id like binary "%"#{text1}"%" or info_type like binary "%"#{text1}"%" or type like binary "%"#{text1}"%" or release1 like binary "%"#{text1}"%"
        or effective_s like binary "%"#{text1}"%" or effective_o like binary "%"#{text1}"%" or compete like binary "%"#{text1}"%" or region like binary "%"#{text1}"%" or product like binary "%"#{text1}"%" or source like binary "%"#{text1  }"%"or content like binary "%"#{text1}"%" or impact like binary "%"#{text1}"%" or stime like binary "%"#{text1}"%" 

同一张表格进行三次不同内容模糊查询。现在需要第一次查询与第二次查询取并级后，产生的结果集再与第三次查询的结果集取交集。SQL语句怎么写呢，用的mysql数据库。spring+mybatis框架

Answer 1

13 23左外关联取交集 然后两个表union 或者12union然后和3左外关联