|
Posted by maraguida on 10/09/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!
Navigation:
[Reply to this message]
|