Optimizer will return parse error if expressions are used on columns in the predicate

Optimizer does not use index if expressions are used on the columns in the predicate, even if one exists

It makes no difference with / without expressions on the columns in the predicate

Using expressions on the columns in the predicate won't get benefits of using Table Alias