Jump to content

How do you exclude data in a Mysql query?


shadrxninga

Recommended Posts

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.