MySQL checks if a query is deterministic then caches the result.
My question is a query like this:
select a from b
where c & 1 and d=100;
This query seems pretty static to me. But will the result get cached? I would like to make sure.
TIA for any help.