is there any way to get a list of reasons when a record in table is not selected from the query? For example, I have this select * from products where color=blue and price=200 and the record with id=5 is not included in the results. How can I print which criteria is false and the record with id=5 is not selected?

CodePudding user response：

I usually just copy the where criteria into the select columns, and select the particular id that wasn't returned, like:

select color=blue, price=200
from products
where id=5