Omzy Posted June 1, 2009 Share Posted June 1, 2009 Can this be simplified at all? SELECT * FROM customers WHERE category=cat1 AND category=cat2 AND category=cat3 AND category=cat4 AND category=cat5 This can just go on and on, so it would be ideal if there was a shorthand version. Thanks! Quote Link to comment Share on other sites More sharing options...
kickstart Posted June 1, 2009 Share Posted June 1, 2009 Hi Can't see how that would work, as a field cannot have multiple values on the same row. However assuming you mean OR instead of AND (and also that category us a numeric field). SELECT * FROM customers WHERE category IN (cat1,cat2,cat3,cat4,cat5) All the best Keith Quote Link to comment Share on other sites More sharing options...
Omzy Posted June 1, 2009 Author Share Posted June 1, 2009 Thanks mate, yes I think I need to use OR instead of AND. Cheers! Quote Link to comment Share on other sites More sharing options...
Maq Posted June 1, 2009 Share Posted June 1, 2009 Thanks mate, yes I think I need to use OR instead of AND. Cheers! Yes, you definitely need to. It's illogical that 'category' could equal 5 different exact values at the same time. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.