Results of an online poll
Hello there, hope in your help.
I need extract from my mysql table the results of an online poll.
- I speak only English Yes No
- I speak only Spanish Yes No
- I speak English and a little bit of Spanish Yes No
- I speak Spanish and a little bit of English Yes No
- I speak English as well as Spanish Yes No
I tried this query:
But how do we count the answer with "No"?
I_speak_only_English = "Yes",
) AS `only_English`
COUNT(*) AS `total`
Please tell me how to resolve this problem ...