Results 1 to 7 of 7
Jul 18, 2002, 02:10 #1
- Join Date
- Mar 2001
- Melbourne, Australia
- 0 Post(s)
- 0 Thread(s)
MySQL question: how to us an 'AS' field in the 'WHERE' clause
Here's my query string:
$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.