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! Link to comment https://forums.phpfreaks.com/topic/160507-solved-multiple-and-conditions/ 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 Link to comment https://forums.phpfreaks.com/topic/160507-solved-multiple-and-conditions/#findComment-847051 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! Link to comment https://forums.phpfreaks.com/topic/160507-solved-multiple-and-conditions/#findComment-847062 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. Link to comment https://forums.phpfreaks.com/topic/160507-solved-multiple-and-conditions/#findComment-847191 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.