when you make a calculated column in mysql and it can not be used in a where clause

This can easily be done using a  nested query as shown in the following snippet taken from https://stackoverflow.com/questions/16068662/calculated-column-in-where-clause-performance

SELECT a,b,c,d FROM 
(SELECT a,b,c,(a*b+c) AS d) AS tmp
WHERE d > n