如何在select语句mysql中回显COUNT数

How to echo COUNT number in select statement mysql?

本文关键字：COUNT mysql select 语句 | 更新日期: 2024-02-23

我想知道如何在select语句中回显COUNT。我想告诉用户有多少用户是匹配的。类似于$count＝count（user_id）；echo$count；

<?php
$stm =$db->prepare("SELECT user FROM tabe WHERE id=1 GROUP BY user_id order by COUNT(user_id) DESC ");
?>

SELECT user,COUNT(user_id) as usercount FROM tabe WHERE id=1 GROUP BY user_id order by usercount DESC