Menu
I have a simple mySQL table which has team1 and team2 along with team1Pts and team2Pts.
I have heaps of teams. But I’ll be doing the follow when considering a specific team ID. Say ID: 1.
Team ID 1, could be team1 or team2 in the database.
I need to find out the most number of times my TeamID 1 has had more points than any other team. AKA a winning streak?
I can list all the winning games with the use of CASE etc.. But not idea if this can be done.