I know think that I've read that one of the following is faster than the other, but I forget which is which:
SELECT * FROM `myTable` WHERE `myDate` > NOW();
SELECT * FROM `myTable` WHERE NOW() < `myDate`;
I know think that I've read that one of the following is faster than the other, but I forget which is which:
SELECT * FROM `myTable` WHERE `myDate` > NOW();
SELECT * FROM `myTable` WHERE NOW() < `myDate`;
The optimizer will produce the same execution plan, realizing that the constant is the same on both sides.