Here's my query string:

PHP Code:
$sql "SELECT LogSessionID, LogTime, FROM_UNIXTIME
(LogTime,'%d-%b-%y') AS LogDate 
What I'd like to do is to extend that query to include (for example)...

WHERE LogDate='18-Jul-02'

...but it appears that any column name that has been renamed using the 'AS' syntax is not available for use in the WHERE clause.

Can anyone:

a) confirm (or otherwise) my observation?
b) suggest a way around this, because it would be real useful to me?

Thanks in anticipation.