Understand your query as the following (explaining the bar conversation mode):
You want to know if there are products of the category 'Dresses' and the color 'White' and if it is not that (OR) that is the color 'Pink', that is, it forgets the two previous conditions and starts to interpret only the latter, or if there are results for the two conditions it returns.
So if the condition color = 'Pink' is part of the condition category = 'Dresses', your query should associate the "OR’s" with parentheses, being:
SELECT * FROM produtos WHERE categoria = 'Vestidos' AND (cor = 'Branco' OR cor = 'Rosa')
The right shape
You can place the full content of your table in the body of the question?
– Leonel Sanches da Silva
The shoe by chance is color = pink, check if the result was not white dress or anything pink?
– NovoK
yes, too! all the records match the color, but the category does not(in case pulled Shoes instead of Dresses as I asked..)
– Rogerio
Do you think the OR there is as if, I ask the SQL dressed in white or Pink color(there could be pink shoe)..
– Rogerio