php - 使用 INTERSECT 运算符时出现 SQL 错误

Question

我正在尝试查找通过基于类别的搜索和关键字搜索找到的结果。但在 phpMyAdmin 中，此代码会引发错误:

SELECT ID, post_title 
FROM wp_5_posts AS p
LEFT JOIN wp_5_term_relationships AS r ON p.ID = r.object_id
WHERE r.term_taxonomy_id
IN (41, 9 )
AND p.post_type = 'attachment'
GROUP BY p.ID
HAVING COUNT(*)>1

INTERSECT

SELECT ID, post_title
FROM wp_5_posts
WHERE post_title
LIKE '%process%'
AND post_type='attachment'

我收到此错误:

“#1064 - 您的 SQL 语法有错误；请检查与您的 MySQL 服务器版本相对应的手册，了解在 'INTERSECTION SELECT ID, post_title FROM wp_5_posts WHERE post_title LIKE '%powd 附近使用的正确语法' 在第 11 行"

有人可以向我解释一下问题是什么吗

Answer 1

你可以尝试这个(未测试)，但概念应该是这样的

SELECT ID, post_title  from (
  (
    SELECT ID, post_title 
    FROM wp_5_posts AS p
    LEFT JOIN wp_5_term_relationships AS r ON p.ID = r.object_id
    WHERE r.term_taxonomy_id IN (41, 9 ) AND p.post_type = 'attachment'
  )
  UNION ALL
  (
    SELECT ID, post_title
    FROM wp_5_posts
    WHERE post_title LIKE '%process%' AND post_type='attachment'
  )
) AS t1 GROUP BY ID HAVING COUNT(*)>1;