My db table is this (semester result table)
regno(int) s1(enum) s2(enum), s3(enum), s4(enum)
I want to find number of subjects in which the student with given id has gotten a particular grade. (ie no of subjects he/she has failed).
Is it possible or shld i change the db design itself?