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 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) 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. 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 Link to comment https://forums.phpfreaks.com/topic/154571-solved-in-clause-help/#findComment-814547 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.