忽略空使用IS NOT NULL不工作 - Ignore empty using IS NOT NULL not working

我有一个查询，它显示了我在TyreMan列中最常见的值。这一列中的很多值都是空的，所以我试图忽略它们，但它似乎没有工作。

$result = mysql_query("SELECT TyreMan, COUNT(TyreMan) AS countTyreMan 
                         FROM Pictures 
                        WHERE Tyreman IS NOT NULL 
                     GROUP BY TyreMan 
                     ORDER BY countTyreMan DESC 
                        LIMIT 1");

我把它放错地方了吗?

谢谢

试一下

      $result = mysql_query("SELECT TyreMan, COUNT(TyreMan) AS countTyreMan 
      FROM Pictures WHERE (Tyreman) IS NOT NULL 
      GROUP BY TyreMan ORDER BY countTyreMan DESC LIMIT 1");

Use () with列名。