t_machine Posted April 2, 2009 Share Posted April 2, 2009 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 Link to comment https://forums.phpfreaks.com/topic/152168-how-to-select-from-mysql-where-one-column-value-is-higher/ Share on other sites More sharing options...
.josh Posted April 2, 2009 Share Posted April 2, 2009 select * from tournament_ids where player_1 > player_2 (* will select all the rows. I suggest you only select the columns you need) Link to comment https://forums.phpfreaks.com/topic/152168-how-to-select-from-mysql-where-one-column-value-is-higher/#findComment-799165 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.