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? 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' 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
Archived
This topic is now archived and is closed to further replies.