Brian W Posted April 17, 2009 Share Posted April 17, 2009 Is there a way to say something like `col1` IN (`col2`) col2 would be a comma separated list of names (created by using GROUP_CONCAT) ? ? ? Any input helpful, thanks Quote Link to comment https://forums.phpfreaks.com/topic/154571-solved-in-clause-help/ Share on other sites More sharing options...
Brian W Posted April 17, 2009 Author Share Posted April 17, 2009 bah, figured it out. Again, subquery prevails. AND 2 IN (SELECT assigned.uid FROM assigned WHERE assigned.tid = t.num) Quote Link to comment https://forums.phpfreaks.com/topic/154571-solved-in-clause-help/#findComment-812799 Share on other sites More sharing options...
fenway Posted April 20, 2009 Share Posted April 20, 2009 You may also be able to convert it to a join, which might be faster. Quote Link to comment https://forums.phpfreaks.com/topic/154571-solved-in-clause-help/#findComment-814474 Share on other sites More sharing options...
Brian W Posted April 20, 2009 Author Share Posted April 20, 2009 I was not able to get it to join correctly, I tried that is many different ways before moving onto IN Quote Link to comment https://forums.phpfreaks.com/topic/154571-solved-in-clause-help/#findComment-814547 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.