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. jeff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php