I have five enum fields, all Y/N. There is now(last minute) a requirment to
report on all clients that said Y to more then one of the questions(its a
survey).  Had i known about this requirement, i could have made them BIT
and had a simple 1/0 option and summed the fields to check the total....

select * from table where sum(ENUM1, ENUM2,ENUM3, ENUM4, ENUM5) > 1; //or
something like that...

anyone have an idea of how i could accomplish the same with Y/N or should i
modify the tables and change them to 1/0's  which is a doable option.

thanks much for any input.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to