在SQL查询的WHERE子句中使用自定义字段

select
*
from
(
    SELECT * , (SELECT COUNT( id ) 
    FROM cms_store_items
    WHERE speaker = cms_store_items_speakers.id
    ) AS count
    FROM cms_store_items_speakers
) a
where a.count > 0
LIMIT 0 , 30

having 条款:

select
    s.id,
    s.col1,
    count(i.speaker) as count
from
    cms_store_items_speakers s
    left join cms_store_items i on
        s.id = i.speaker
group by
    s.id,
    s.col1
having
    count(i.speaker) > 0
limit 0, 30

你可以使用 HAVING

...
) AS count
FROM cms_store_items_speakers
HAVING count > 0
LIMIT 0 , 30

有 WHERE 但它能够处理计算出的列。 警告: 查询的其余部分已运行-它不能替代 哪里 条款

我不是100%确定mysql,但是类似这样的东西应该是非常可能的:

(SELECT 
     *
FROM
(
   SELECT cms_store_items_speakers.*,
          (SELECT COUNT(id) FROM cms_store_items
           WHERE speaker = cms_store_items_speakers.id) AS 'count'
   FROM cms_store_items_speakers)
   LIMIT 0, 30
)
WHERE count > 0;