MySQL query help please?
I have a customer survey table, in which the basic format is
want_moredisk enum(Y, N)
want_morebandwidth enum(Y, N)
I want to write a query which will tell me that 200 respondents wanted more disk, 156 wanted more bandwidth, and so on down the line (50+ columns of things they may want).
It seems like this should be simple but I am hitting a brick wall.
Also, some of my columns are enum(Y,N), but ask what features they appreciate most:
and so on.
Is there a way to filter results by column name? Where columnname like 'appr_%' ?
Really I'm not a MySQL newbie... just blanking out this morning.
Thanks for any help.
Former Hosting Company Owner