SEVIZ Posted April 19, 2009 Share Posted April 19, 2009 Another easy one that I cannot find. ARGH SELECT `dept` FROM `sprint` WHERE dept='T_LEAD' GROUP BY `dept` How do I add another thing with T_LEAD above? I want the WHERE dept= to look for T_LEAD and T_SUP. Comma does not work, nor space. Link to comment https://forums.phpfreaks.com/topic/154712-solved-where-more-than-one-thing/ Share on other sites More sharing options...
JasonLewis Posted April 19, 2009 Share Posted April 19, 2009 SELECT * FROM table WHERE something='true' AND something='false' Link to comment https://forums.phpfreaks.com/topic/154712-solved-where-more-than-one-thing/#findComment-813534 Share on other sites More sharing options...
SEVIZ Posted April 19, 2009 Author Share Posted April 19, 2009 Ok I did this: SELECT `dept` FROM `sprint` WHERE dept='T_LEAD' AND dept='T_SUP' GROUP BY `dept` But it doesn't work. I am such a noob I apologize. Link to comment https://forums.phpfreaks.com/topic/154712-solved-where-more-than-one-thing/#findComment-813536 Share on other sites More sharing options...
JasonLewis Posted April 19, 2009 Share Posted April 19, 2009 My bad, make it OR not AND. Link to comment https://forums.phpfreaks.com/topic/154712-solved-where-more-than-one-thing/#findComment-813540 Share on other sites More sharing options...
SEVIZ Posted April 19, 2009 Author Share Posted April 19, 2009 Cha Ching! Thanks! Link to comment https://forums.phpfreaks.com/topic/154712-solved-where-more-than-one-thing/#findComment-813541 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.