SELECT `prov`, `log` , `name` , count(*) as `count` FROM syslog WHERE `time` LIKE "Dec 20 %" AND `prov` = 'NB' AND `count` >= 20 GROUP By `prov`, `log`,`name` ORDER BY `count` DESC
I get an error says column `count` does not exist when I add the `count` >= 20?
I might be doing this wrong, but it has worked before?
You can't use a column alias in a where clause and this query really isn't making any sense to me.
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.