Excluding a row

First off hi everyone
Ok, right now I use this script to retrieve top 3 "Old School Games" which is in the "category" row in mySQL

Now I want to retrieve top 3 games from every category except "Old School Games"

I tried this

But it didn't work. The red area is what I am having problems with. Does anyone know how I would accomplish gathering the top 3 games from all the categories except 'Old School Games'? Hopefully I am not to confusing.

Thanks in advance for any help

 

Don't know MySQL that well, but doesn't it support the != operator?

$sql2 = "SELECT * FROM games Where category!='Old School Games' ORDER BY played DESC LIMIT 0,3";

Code (markup):

 

Bob has it right, (at least in most current versions of mysql) this will work:

Where category!='Old School Games'

The code != is telling mysql "DOES NOT EQUAL"

 

If i'm not mistaken you can also use

which also does the same.

 

thanks guy