codeline Posted February 6, 2011 Share Posted February 6, 2011 Is there a way to query some information depending on if a table field DOES NOT include a specific value? I've got a table that contains over 100 locations. I want to organize the data on the frontend by country (specifically US and International). How would I go about filtering out locations that DO NOT belong in USA? $q = "SELECT * FROM table WHERE COUNTRY='USA'"; Link to comment https://forums.phpfreaks.com/topic/226895-querying-depending-on-field-value-in-db/ Share on other sites More sharing options...
Pikachu2000 Posted February 6, 2011 Share Posted February 6, 2011 "SELECT * FROM table WHERE COUNTRY != 'USA'"; Link to comment https://forums.phpfreaks.com/topic/226895-querying-depending-on-field-value-in-db/#findComment-1170712 Share on other sites More sharing options...
codeline Posted February 6, 2011 Author Share Posted February 6, 2011 Wow.. didn't think it would be that simple and take the "not equal to" operator. Thanks! Link to comment https://forums.phpfreaks.com/topic/226895-querying-depending-on-field-value-in-db/#findComment-1170719 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.