immanuelx2 Posted July 6, 2009 Share Posted July 6, 2009 SELECT * FROM table WHERE tag != 'tag1' AND tag != 'tag2' AND tag != 'tag3' AND tag != 'tag4' AND tag != 'tag5' Can i do something like.. WHERE tag NOT IN ('tag1','tag2','tag3','tag4','tag5') ? Quote Link to comment https://forums.phpfreaks.com/topic/164965-more-efficient-way-of-doing-this/ Share on other sites More sharing options...
rhodesa Posted July 6, 2009 Share Posted July 6, 2009 Yup, that syntax should work fine Quote Link to comment https://forums.phpfreaks.com/topic/164965-more-efficient-way-of-doing-this/#findComment-869856 Share on other sites More sharing options...
fenway Posted July 10, 2009 Share Posted July 10, 2009 Yes, but it will be very slow. Quote Link to comment https://forums.phpfreaks.com/topic/164965-more-efficient-way-of-doing-this/#findComment-872504 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.