I am trying to get all unread messages from my Inbox. If I try following query:

SELECT *
FROM ymail.messages
WHERE messageInfo.flags.isRead=1
AND numMid=100

I get THE same result as this query:

SELECT *
FROM ymail.messages
WHERE messageInfo.flags.isRead=0
AND numMid=100

that is I get only first 100 message, irrespectively of whether the message has isRead flag set or unset.

Can anybody help me. What am I doing wrong here?

I have also tried following query:

SELECT * FROM ymail.search WHERE read="0" 

but I could not get filter by folder name working.

Thanks for any and all responses! :)