MySQL查询使用NOT在其中，可能 - MySQL Query using NOT in it, possible?

MySQL Query using NOT in it, possible?

本文关键字：在其中可能 NOT 查询 MySQL | 更新日期: 2023-09-27

我有一个订单状态数据库，我想返回该行的值不是Complete的行数。

我该怎么做？下面显示了有多少行的订单状态为"New"。但我想显示除od_status为Complete之外的所有行。

<?php
$query = "SELECT od_status FROM tbl_order WHERE od_status = 'New'"; 
$result = mysql_query($query) or die(mysql_error());
$num_rows = mysql_num_rows($result);
echo "$num_rows";
?>

<?php
$query = "SELECT od_status FROM tbl_order WHERE od_status != 'Complete'"; 
$result = mysql_query($query) or die(mysql_error());
$num_rows = mysql_num_rows($result);
echo "$num_rows";
?>

$query = "SELECT od_status FROM tbl_order WHERE od_status <> 'Complete'";

$query = "SELECT COUNT(*) FROM tbl_order WHERE od_status != 'Complete'";
$result = mysql_query($query);
var_dump($result);

COUNT计算行数和！=选择不等于"完成"的位置。