pouncer Posted April 13, 2007 Share Posted April 13, 2007 select * from items where group != "" how do i use != in sql? im trying to get the items where the 'group' field is not null Link to comment https://forums.phpfreaks.com/topic/46930-not-query/ Share on other sites More sharing options...
per1os Posted April 13, 2007 Share Posted April 13, 2007 $sql = "SELECT * FROM items WHERE group <> ''"; Try that. Link to comment https://forums.phpfreaks.com/topic/46930-not-query/#findComment-228850 Share on other sites More sharing options...
pouncer Posted April 13, 2007 Author Share Posted April 13, 2007 awesome, thanks. Link to comment https://forums.phpfreaks.com/topic/46930-not-query/#findComment-228855 Share on other sites More sharing options...
per1os Posted April 13, 2007 Share Posted April 13, 2007 And just a side note, if you are checking against null values you would need this: $sql = "SELECT * FROM items WHERE group IS NOT NULL"; Just a side note. Link to comment https://forums.phpfreaks.com/topic/46930-not-query/#findComment-228859 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.