mysql query to select rows based on count

Question

i have this database

i want to select options_e if it has options less than 4, or something like this

SELECT * FROM `options` WHERE count(qid) <4

so that it will return the result of options who are less than 4. but on phpmyadmin when i run the query, it says invalid use of group function. why do I get this error? who can i fix this?

Rahul Tripathi · Accepted Answer · 2015-11-16 11:05:46Z

2

You can try like this:

SELECT options_e, options_f, options_p, options_a, options_s  FROM `options`
GROUP BY options_e, options_f, options_p, options_a, options_s
HAVING count(qid) < 4

answered Nov 16, 2015 at 11:05

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

mysql query to select rows based on count

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related