How to select from mysql where one column value is higher

[t_machine]

I hope someone can help with this problem.

 

I have a table that stores vote count with the following columns: tournament_id,  player_1 and player_2.

How can I select from my table all "tournament_ids" where "player_1" has more votes than "player_2"

 

Thanks

 

[.josh]

select * from tournament_ids where player_1 > player_2

 

(* will select all the rows. I suggest you only select the columns you need)