blocks|key|2890041|text|尝试此查询，只需将status更改为状态列的名称：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2890042|SELECT+COUNT(*)+as+Total+FROM+cases+WHERE+status+=+"OPEN"|code-block|syntax|javascript|2890043|entityMap^0|9|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

<p>Try this query, just change <code>status</code> to the name of the column of the statuses:</p>

<pre><code>SELECT COUNT(*) as Total FROM cases WHERE status = "OPEN"
</code></pre>


blocks|key|1178392|text|如果是in+status+it+can+only+be+OPEN+og(or?)+CLOSED，则此查询最多为2行，并对这两种状态进行计数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1178393|select+count(*)+as+cnt,+status+from+t+group+by+status|code-block|syntax|javascript|1178394|entityMap^0|3|18|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

<p>If <code>in status it can only be OPEN og(or?) CLOSED</code>, then this query gives you maximum 2 rows, with count of both statuses.</p>

<pre><code>select count(*) as cnt, status from t group by status
</code></pre>


blocks|key|1178407|text|试着为你做这件事|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1178408|+$sql="SELECT+status,+COUNT()+as+count+FROM+cases+WHERE+status+=+'ÅBEN'+UNION+ALL+SELECT+status,+COUNT()+FROM+cases+WHERE+status+=+'LUKKET'";|code-block|syntax|javascript|1178409|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>try this its work for you</p>

<pre><code> $sql="SELECT status, COUNT() as count FROM cases WHERE status = 'ÅBEN' UNION ALL SELECT status, COUNT() FROM cases WHERE status = 'LUKKET'";
</code></pre>


blocks|key|2890100|text|您可以使用mysql的案例方法检查状态。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2890101|SELECT+SUM(CASE+WHEN+status+=+'OPEN'+THEN+1+ELSE+0+END)+AS+'Open',+SUM(CASE+WHEN+status+=+'CLOSED'+THEN+1+ELSE+0+END)+AS+'Closed'+FROM+cases|code-block|syntax|javascript|2890102|如果对你有用，请告诉我。|2890103|在PHP中|blockquote|2890104|<?php+
if+(mysqli_connect_errno())+{+
++echo+"Failed+to+connect+to+MySQL:+"+.+mysqli_connect_error();+
++}
++$sql="SELECT+SUM(CASE+WHEN+status+=+'OPEN'+THEN+1+ELSE+0+END)+AS+'Open',+SUM(CASE+WHEN+status+=+'CLOSED'+THEN+1+ELSE+0+END)+AS+'Closed'+FROM+cases";+
++if+($result=mysqli_query($con,$sql))+{
+++//+Return+the+number+of+rows+in+result+set+
++++$rowcount=mysqli_num_rows($result);+
++++printf("%25d",$rowcount);+//+Free+result+set
++++$row+=+mysqli_fetch_array($result,+MYSQLI_ASSOC);
++++mysqli_free_result($result);+
++}
++mysqli_close($con);
?>|2890105|在HTML中|2890106|<div+class="row">
<div+class="col-lg-2+col-sm-4">
++<div+class="circle-tile">
++++<a+href="#"><div+class="circle-tile-heading+green"><i+class="fa+fa-commenting-o+fa-fw+fa-3x"></i></div></a>
++++<div+class="circle-tile-content+green">
++++++<div+class="circle-tile-description+text-faded">+Åbne+sager</div>
++++++<div+class="circle-tile-number+text-faded+"><?php+echo+$row['OPEN'];?></div>
++++++<a+class="circle-tile-footer"+href="#">Mere+info+<i+class="fa+fa-chevron-circle-right"></i></a>
++++</div>
++</div>
</div>

<div+class="col-lg-2+col-sm-4">
++<div+class="circle-tile+">
++++<a+href="#"><div+class="circle-tile-heading+red"><i+class="fa+fa-check+fa-fw+fa-3x"></i></div></a>
++++<div+class="circle-tile-content+red">
++++++<div+class="circle-tile-description+text-faded">+Lukket+sager+</div>
++++++<div+class="circle-tile-number+text-faded+"><?php+echo+$row['CLOSED'];?></div>
++++++<a+class="circle-tile-footer"+href="#">Mere+Info+<i+class="fa+fa-chevron-circle-right"></i></a>
++++</div>
++</div>
</div>|2890107|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/case.html^0|B|2|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@$A|12|B|13|1|14]]|C|$]]|$1|D|3|E|5|F|7|15|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|16|8|@]|9|@]|C|$]]|$1|K|3|L|5|M|7|17|8|@]|9|@]|C|$]]|$1|N|3|O|5|F|7|18|8|@]|9|@]|C|$G|H]]|$1|P|3|Q|5|M|7|19|8|@]|9|@]|C|$]]|$1|R|3|S|5|F|7|1A|8|@]|9|@]|C|$G|H]]|$1|T|3|-4|5|6|7|1B|8|@]|9|@]|C|$]]]|U|$V|$5|W|X|Y|C|$Z|10]]]]

<p>You can use the <a href="https://dev.mysql.com/doc/refman/5.7/en/case.html" rel="nofollow noreferrer">CASE</a> method of mysql to check the status</p>

<pre><code>SELECT SUM(CASE WHEN status = 'OPEN' THEN 1 ELSE 0 END) AS 'Open', SUM(CASE WHEN status = 'CLOSED' THEN 1 ELSE 0 END) AS 'Closed' FROM cases
</code></pre>

<p>Let me know if it works for you</p>

<blockquote>
  <p>In PHP</p>
</blockquote>

<pre><code>&lt;?php 
if (mysqli_connect_errno()) { 
  echo "Failed to connect to MySQL: " . mysqli_connect_error(); 
  }
  $sql="SELECT SUM(CASE WHEN status = 'OPEN' THEN 1 ELSE 0 END) AS 'Open', SUM(CASE WHEN status = 'CLOSED' THEN 1 ELSE 0 END) AS 'Closed' FROM cases"; 
  if ($result=mysqli_query($con,$sql)) {
   // Return the number of rows in result set 
    $rowcount=mysqli_num_rows($result); 
    printf("%d",$rowcount); // Free result set
    $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
    mysqli_free_result($result); 
  }
  mysqli_close($con);
?&gt;
</code></pre>

<blockquote>
  <p>IN HTML</p>
</blockquote>

<pre><code>&lt;div class="row"&gt;
&lt;div class="col-lg-2 col-sm-4"&gt;
  &lt;div class="circle-tile"&gt;
    &lt;a href="#"&gt;&lt;div class="circle-tile-heading green"&gt;&lt;i class="fa fa-commenting-o fa-fw fa-3x"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/a&gt;
    &lt;div class="circle-tile-content green"&gt;
      &lt;div class="circle-tile-description text-faded"&gt; Åbne sager&lt;/div&gt;
      &lt;div class="circle-tile-number text-faded "&gt;&lt;?php echo $row['OPEN'];?&gt;&lt;/div&gt;
      &lt;a class="circle-tile-footer" href="#"&gt;Mere info &lt;i class="fa fa-chevron-circle-right"&gt;&lt;/i&gt;&lt;/a&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;div class="col-lg-2 col-sm-4"&gt;
  &lt;div class="circle-tile "&gt;
    &lt;a href="#"&gt;&lt;div class="circle-tile-heading red"&gt;&lt;i class="fa fa-check fa-fw fa-3x"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/a&gt;
    &lt;div class="circle-tile-content red"&gt;
      &lt;div class="circle-tile-description text-faded"&gt; Lukket sager &lt;/div&gt;
      &lt;div class="circle-tile-number text-faded "&gt;&lt;?php echo $row['CLOSED'];?&gt;&lt;/div&gt;
      &lt;a class="circle-tile-footer" href="#"&gt;Mere Info &lt;i class="fa fa-chevron-circle-right"&gt;&lt;/i&gt;&lt;/a&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;
</code></pre>


blocks|key|1204873|text|++<div+class="row">
<div+class="col-lg-2+col-sm-4">
++<div+class="circle-tile">
++++<a+href="#"><div+class="circle-tile-heading+green"><i+class="fa+fa-commenting-o+fa-fw+fa-3x"></i></div></a>
++++<div+class="circle-tile-content+green">
++++++<div+class="circle-tile-description+text-faded">+Åbne+sager</div>
++++++<div+class="circle-tile-number+text-faded+">HERE+TO+INCLUDE+ALL+OPEN+CASES</div>
++++++<a+class="circle-tile-footer"+href="#">Mere+info+<i+class="fa+fa-chevron-circle-right"></i></a>
++++</div>
++</div>
</div>

<div+class="col-lg-2+col-sm-4">
++<div+class="circle-tile+">
++++<a+href="#"><div+class="circle-tile-heading+red"><i+class="fa+fa-check+fa-fw+fa-3x"></i></div></a>
++++<div+class="circle-tile-content+red">
++++++<div+class="circle-tile-description+text-faded">+Lukket+sager+</div>
++++++<div+class="circle-tile-number+text-faded+">HERE+TO+INCLUDE+ALL+CLOSED+CASES</div>
++++++<a+class="circle-tile-footer"+href="#">Mere+Info <i+class="fa+fa-chevron-circle-right"></i></a>
++++</div>
++</div>
</div>+|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1204874|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>  &lt;div class="row"&gt;
&lt;div class="col-lg-2 col-sm-4"&gt;
  &lt;div class="circle-tile"&gt;
    &lt;a href="#"&gt;&lt;div class="circle-tile-heading green"&gt;&lt;i class="fa fa-commenting-o fa-fw fa-3x"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/a&gt;
    &lt;div class="circle-tile-content green"&gt;
      &lt;div class="circle-tile-description text-faded"&gt; Åbne sager&lt;/div&gt;
      &lt;div class="circle-tile-number text-faded "&gt;HERE TO INCLUDE ALL OPEN CASES&lt;/div&gt;
      &lt;a class="circle-tile-footer" href="#"&gt;Mere info &lt;i class="fa fa-chevron-circle-right"&gt;&lt;/i&gt;&lt;/a&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt;

&lt;div class="col-lg-2 col-sm-4"&gt;
  &lt;div class="circle-tile "&gt;
    &lt;a href="#"&gt;&lt;div class="circle-tile-heading red"&gt;&lt;i class="fa fa-check fa-fw fa-3x"&gt;&lt;/i&gt;&lt;/div&gt;&lt;/a&gt;
    &lt;div class="circle-tile-content red"&gt;
      &lt;div class="circle-tile-description text-faded"&gt; Lukket sager &lt;/div&gt;
      &lt;div class="circle-tile-number text-faded "&gt;HERE TO INCLUDE ALL CLOSED CASES&lt;/div&gt;
      &lt;a class="circle-tile-footer" href="#"&gt;Mere Info &lt;i class="fa fa-chevron-circle-right"&gt;&lt;/i&gt;&lt;/a&gt;
    &lt;/div&gt;
  &lt;/div&gt;
&lt;/div&gt; 
</code></pre>


<p>I'm stuck in my code! </p>

<p>In my db, I have these columns: </p>

<blockquote>
  <p>id | name | mail | status | date</p>
</blockquote>

<p>in <code>status</code> it can only be OPEN or CLOSED. </p>

<p>Now I have more then 100 rows in my db and want to find out how many are <strong>OPEN</strong> and how many are <strong>CLOSED</strong>, but I cant figure out how to do this.</p>

<p>I've tried to write a lot of post here at the page, but no one is getting me the right answer. </p>

<p>I wrote this code: </p>

<pre><code>$query = "SELECT status, COUNT(OPEN) FROM cases GROUP BY status ORDER BY COUNT(status) desc";
$result = mysql_query($query);


&lt;?php echo($result); ?&gt;
</code></pre>

<p>Now I hoped to get the result like this:</p>

<blockquote>
  <p>53</p>
</blockquote>


MySQL select count(*) function to find all status with OPEN

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我被我的密码卡住了！在我的数据库中，我有以下列：id \ name \ mail / status / date在status中，只能打开或关闭。现在，我的数据库中有超过100行，我想知道有多少行是OPEN，有多少行是关闭的，但是我不知道如何做到这一点。我试着在这里写了很多文章，但是没有人给我正确的答案。我写了这段代码...

问MySQL选择count(*)函数查找打开的所有状态
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL选择count(*)函数查找打开的所有状态EN