This is probably straight forward, but say I had a table:

person_id  surname  console  game
1          jones    xbox360  cod4
2          bloggs   ps3      cod4
3          smith    wii      bowling
4          another  xbox360  cod4
If I wanted to execute a query asking if the table has the same game on both xbox360 and ps3, how would I go about doing that? So the condition would be TRUE for the table above because of rows 1 and 2 (xbox360 and ps3=cod4).

Any advice appreciated.