Request an SQL statement

MySQL condition calculation

Table A, field Ax,ay,az
Table B, Field BX,BY,BZ

$time = time (), select *, (A.AZ*7+B.BZ) as exp WHERE exp<= '. $time. ' ORDER by A.ay;

Like this by calculating a temporary column exp, and then to determine whether the value of exp is less than a number of SQL statements should be how to write? I write this after the hint syntax error: Unknown column ' exp ' in ' WHERE clause '

Reply to discussion (solution)

.... (a.az*7+b.bz) <= '. $time. ' ....

SQL is right-to-left, so there is no definition of exp in where.

Have a try and have it.

SELECT *, (A.AZ*7+B.BZ) as exp having exp<= '. $time. ' ORDER by A.ay;

