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 Quote 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) Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.