<div>
Angel thanks! &nbsp;I'll give it a try now
</div>


<div>
Thank you sir! &nbsp;Much appreciated!
</div>


<div>
<div class="content wysiwyg-content">
Experts, I'm using the query below to pull data from the db, and want to add a clause of WHERE count(misconcepion) &gt;=4, but I keep getting an error when I do. &nbsp;Can someone tell me how to add this clause to my query?<br />
<br />
Thanks<br />
Nick<br />
<br />
query:<br />
<br />
SELECT ss.studentID, s.fName,s.lName, count(misconception) AS misc<br />
FROM studentmisconceptionreport<wbr /> ss<br />
INNER JOIN students s on s.studentID = ss.studentID<br />
WHERE itemsetID = 65<br />
group by ss.studentID
</div>
</div>


Experts, I'm using the query below to pull data from the db, and want to add a clause of WHERE count(misconcepion) >=4, but I keep getting an error when I do.  Can someone tell me how to add this clause to my query?

Thanks
Nick

query:

SELECT ss.studentID, s.fName,s.lName, count(misconception) AS misc
FROM studentmisconceptionreport ss
INNER JOIN students s on s.studentID = ss.studentID
WHERE itemsetID = 65
group by ss.studentID

Query Count

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.