https://www.webmaster-forums.net/crss/node/1041076 en https://www.webmaster-forums.net/web-programming-and-application-development/mysql-query-use-count-or-select#comment-1229912 <p>Interesting, thanks.</p> Sat, 03 May 2008 20:55:29 +0000 greg comment 1229912 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-programming-and-application-development/mysql-query-use-count-or-select#comment-1229845 <p>For your first questions: Have you looked into a GROUP BY? This would probably work for you:</p> <p><div class="codeblock"><code>SELECT Age, COUNT(Age) AS AgeCnt FROM User WHERE Age IN(20, 25, 30, 35, 40) GROUP BY Age</code></div>'</p> Tue, 29 Apr 2008 16:35:02 +0000 teammatt3 comment 1229845 at https://www.webmaster-forums.net