MySQL question: how to us an 'AS' field in the 'WHERE' clause
Here's my query string:
What I'd like to do is to extend that query to include (for example)...
$sql = "SELECT LogSessionID, LogTime, FROM_UNIXTIME
(LogTime,'%d-%b-%y') AS LogDate
...but it appears that any column name that has been renamed using the 'AS' syntax is not available for use in the WHERE clause.
a) confirm (or otherwise) my observation?
b) suggest a way around this, because it would be real useful to me?
Thanks in anticipation.