> -----Original Message----- > From: Chris Mason [mailto:masonc@;masonc.com] > [...] > The problem is, it is easy to test for one amenity, but I need to test > that the hotel has all of the amenities. The query above > returns all the > hotels that have ANY of the amenities, I need the hotels having ALL of > the amenties only.
Try turning the problem around. Instead of including only the hotels having all desired amenities, you might get the results you want by excluding any hotels _lacking_ a desired amenity. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php