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'"; Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted February 6, 2011 Share Posted February 6, 2011 "SELECT * FROM table WHERE COUNTRY != 'USA'"; Quote Link to comment 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! Quote Link to comment 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.