|
Posted by Andy Hassall on 10/09/69 11:36
On Wed, 4 Jan 2006 17:05:27 +0100, "Geradeaus"
<gehegeradeaus_nospam_@hotmail.com> wrote:
>I have searched but have not yet found how I can resolve the following
>problem :
>
>SELECT adId,
> CASE
> WHEN adId =1 THEN cityId
> WHEN adId =2 THEN regionId
> END AS extraField
>FROM ad
>WHERE extraField <> 0
>
>The problem is "extraField" cannot be used in the WHERE clause... I am using
>mySQL 4.1
Repeat the CASE in the WHERE clause.
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool
Navigation:
[Reply to this message]
|