mysql - 如何在多表搜索中找到我的结果表？

Question

我在两个表中搜索一个字符串。

$sql="SELECT download.title FROM download
      WHERE download.title LIKE '%$search%' 
      UNION 
      SELECT news.title FROM news
      WHERE news.title LIKE '%$search%' OR news.text LIKE '%$search%' ";  

如何找出我找到的记录来自哪个表？

Answer 1

为什么不在结果集中添加鉴别器列？这使您能够查询一次，并按来源获取结果。

SELECT 'DOWNLOAD' AS SOURCE, download.title FROM download WHERE download.title LIKE '%$search%' 
UNION ALL
SELECT 'NEWS', news.title FROM news WHERE news.title LIKE '%$search%' OR news.text LIKE '%$search%';