asmith Posted December 28, 2007 Share Posted December 28, 2007 can i use IN statement for specifing some values not to be ? like : select * from table where id in (2,5,7) // i want the opposite of this sentence Link to comment https://forums.phpfreaks.com/topic/83461-solved-opposite-of-in/ Share on other sites More sharing options...
rajivgonsalves Posted December 28, 2007 Share Posted December 28, 2007 its select * from table where id not in (2,5,7) // i want the opposite of this sentence you answered your own question Link to comment https://forums.phpfreaks.com/topic/83461-solved-opposite-of-in/#findComment-424623 Share on other sites More sharing options...
asmith Posted December 28, 2007 Author Share Posted December 28, 2007 thanks a lot rajiv Link to comment https://forums.phpfreaks.com/topic/83461-solved-opposite-of-in/#findComment-424629 Share on other sites More sharing options...
rajivgonsalves Posted December 28, 2007 Share Posted December 28, 2007 Always welcome glad to be of help!! Link to comment https://forums.phpfreaks.com/topic/83461-solved-opposite-of-in/#findComment-424632 Share on other sites More sharing options...
asmith Posted December 28, 2007 Author Share Posted December 28, 2007 i've already wish you luck in any field of life ! Link to comment https://forums.phpfreaks.com/topic/83461-solved-opposite-of-in/#findComment-424635 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.