You can use "having" instead of "where" with an alias.
Bernard
On Thursday 12 February 2004 14:46, Ian O'Rourke wrote:
> Is it possible to have a 'worked out value' in the WHERE clause. The
> problem I have is what I need to check for in the WHERE Clause is not a
> column:
>
> SELECT
> CONCAT_WS("-",DATE_FORMAT(EntryDate,'%c'),DATE_FORMAT(EntryDate,'%Y')) As
> mthyr
> From Blogs
> WHERE mthyr=1-2003
>
> This does not work as it seems to want a valid column in the WHERE clause.
> Anyway around it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
