The equal sign is a reserved character. Using it in a search requires you escape it or enclose it in quotation marks. However, because it is reserved it is not indexed unless you use Unicode indexing. The same applies to the "@" symbol and all the other reserved characters. Makes it difficult to search for - email@example.com - in an email address field unless you enclose the whole address in quotes.
"1 = Yes" is not searching for the equal sign.
"1 \= Yes" should properly search for the equal sign, however it will be a slower search as its an unindexed search.
Thanks a lot for answering my question. I really appreciate your reply.