shadrxninga Posted January 25, 2011 Share Posted January 25, 2011 How would i exclude data from a query if it was = to something query = mysql_query("SELECT player, count(player) AS num FROM bbdata WHERE action='0' AND type IN (15, 14, 56) AND rbacked = '0' GROUP BY player ORDER BY num DESC ;"); What I want to do is exclude "shadrxninga"(Which is under player in the table)from the query so something like this query = mysql_query("SELECT player, count(player) AS num FROM bbdata WHERE action='0' AND type IN (15, 14, 56) AND rbacked = '0' EXCLUDE player = 'shadrxninga' GROUP BY player ORDER BY num DESC ;"); So how would I do that? Quote Link to comment https://forums.phpfreaks.com/topic/225594-how-do-you-exclude-data-in-a-mysql-query/ Share on other sites More sharing options...
Pikachu2000 Posted January 25, 2011 Share Posted January 25, 2011 AND `player` != 'shadrxninga' Quote Link to comment https://forums.phpfreaks.com/topic/225594-how-do-you-exclude-data-in-a-mysql-query/#findComment-1164856 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.