Posted by Geradeaus on 10/05/57 11:36

"Andy Hassall" <andy@andyh.co.uk> schreef in bericht
news:tk2or1dp3lu97bnii8umplektaplm8ovc9@4ax.com...
> 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

thanks when I repeat it, it works :)

[Back to original message]