如何从主查询中选择计数到子查询中

我想将主查询中选择的记录数获取到子查询中

我当前尝试执行的查询是：

SELECT cat_id,category_name,seo_name,(SELECT count(category_name) FROM ccs_coupons WHERE (category_name LIKE category_name OR website_name LIKE category_name OR description LIKE LIKE category_name OR url_desc LIKE category_name )) FROM  `ccs_coupons` WHERE  category_name like 'a%' GROUP BY category_name ORDER BY category_name ASC LIMIT $page,$config 

你不能把HAVING外部查询上的子句，因为它不是聚合查询。试试这个：

SELECT users.id,
       users.display_name, 
       COUNT(*) AS comments_count 
  FROM users 
  INNER JOIN cms_comments 
  ON users.id = cms_comments.author_id
GROUP BY users.id, users.display_name
HAVING COUNT(*) > 150;