Tag: MySQL Query

How would you select all the members, whose phone number is null?

SELECT * FROM members WHERE ISNULL(phonenumber);

How would you write a query to select all players that won either 1, 5, 9 or 14 games?

SELECT player_name FROM games WHERE player_won IN (1, 5, 9, 14)