asmith Posted December 11, 2007 Share Posted December 11, 2007 can i select from mysql tables where some column aren't equal so eomthing ? like select * from table where name != john ? all rows execpt the rows which their name is john . is that possible ? Link to comment https://forums.phpfreaks.com/topic/81192-select-where-arent/ Share on other sites More sharing options...
trq Posted December 11, 2007 Share Posted December 11, 2007 Funnily enough.... select * from table where name != 'john' Link to comment https://forums.phpfreaks.com/topic/81192-select-where-arent/#findComment-411986 Share on other sites More sharing options...
asmith Posted December 11, 2007 Author Share Posted December 11, 2007 didnt know mysql have ! sybbol as the way it works in php !!!!! Link to comment https://forums.phpfreaks.com/topic/81192-select-where-arent/#findComment-411999 Share on other sites More sharing options...
fenway Posted December 11, 2007 Share Posted December 11, 2007 Just remember this isn't index-friendly. Link to comment https://forums.phpfreaks.com/topic/81192-select-where-arent/#findComment-412160 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.