Posted by Geradeaus on 10/08/27 11:36

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

Thanks in advance!

• Next in forum: indenting
• Prev in forum: Re: Can GD load an image from another php script?
• Thread view: mysql question : CASE

[Reply to this message]