php - 如何计算与此查询中的字符串文本匹配的数据数量？

Question

mysql_query("SELECT DISTINCT lo_category FROM questions where question_text = '" . mysql_real_escape_string($_GET["choice"]) . "'");

因此，从上面的查询中，我将获得与选择匹配的 lo_categories。我如何获得类别的数量，例如

Category Cognitive : 3 matches
Category Psychomotor : 1 matches
Category Perception : 0 matches

($_GET["choice"]) 来自具有多个选择的 html 复选框。这是我的问题表。

question_id  question_text               keyword  lo_category lo_domain
      1     Define the word paraphrase    Define  Knowledge   Cognitive 
      2     describe the meaning of NLP  describe Knowledge   Cognitive 
      3     describe the meaning of NLP  describe Perception  Psychomotor 
      4     describe the meaning of NLP  describe Receiving   Affective 
      5     Define this                    Define Knowledge   Cognitive

更新了这个，有错误。请帮助我迷路!!!

$yes=mysql_query("select lo_category, count(*) from questions where question_text='" . mysql_real_escape_string($_GET["choice"]) . "' group by lo_category order by lo_category");

while ($row = mysql_fetch_assoc($yes)) {
    echo '<b>Category :</b> ' . $row['lo_category'] . ',' . $row['count(*)'] . '<br />'; 
}

请帮助我，我是这方面的初学者..提前致谢!!!

Answer 1

select lo_category, count(lo_category) as countOflo_category group by lo_category