SQL Select Statement with WHERE, AND, OR

user_412801 0
Viewed 89999

I would like to perform a SELECT query with MySQL. My goal is to select all the dogs in a vet database that would be sex=male and fur=short and (color=black or size=big)

Note: I want to select dogs that are either black or size is big. They don't have to fulfill the 2 requirements. They just need to fulfill either one.

I have written the SQL statement below but I'm not not sure if I'm right:

SELECT name, sex, fur, color 
FROM dogs 
WHERE TRUE sex='male' AND fur='short' AND color='black' OR size="big";

Pardon my phrasing if it's too confusing.

where select mysql operators
5 Answers

select name, sex, fur,color from dogs where sex ='male' and fur = 'short' and (color ='black' or size ='big');

user_28135670
Related