SELECT team_name FROM team WHERE team_won IN (1, 3, 5, 7);
To select all teams that won either 1, 3, 5, or 7 games in MySQL, you can use the following query:
SELECT *
FROM teams
WHERE wins IN (1, 3, 5, 7);
This query selects all rows from the teams
table where the wins
column has a value of 1, 3, 5, or 7. Adjust the table and column names according to your schema.