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 Quote 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 Quote 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 Quote 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!! Quote 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 ! Quote Link to comment https://forums.phpfreaks.com/topic/83461-solved-opposite-of-in/#findComment-424635 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.