Posted by maraguida on 10/11/64 11:36

You might want to try comp.databases.mysql for comprehensive answers.
(X-Post and Followup-To set)

Geradeaus 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

....
WHERE adId in (1, 2)

not tested!

[Back to original message]