GROUP BY clause and CASE statement – need help

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
rahulephp
Forum Commoner
Posts: 28
Joined: Mon Oct 05, 2009 11:05 am

GROUP BY clause and CASE statement – need help

Post by rahulephp »

I have a table with 4 columns

Table name = products
Column name = product_id, product_programname, product_title, model_number

When I use GROUP BY with model_number, it alway returns me the info of product (ebay) which comes first in the queue.
But i want to get the title from 'argos' if not null else 'buy' if not null etc.

The below query doesn't works for me.

Code: Select all

SELECT *,
(
case(true)
WHEN product_programname = 'argos' AND product_programname IS NOT NULL
THEN product_title

WHEN product_programname = 'buy' AND product_programname IS NOT NULL
THEN product_title

WHEN product_programname = 'amazon' AND product_programname IS NOT NULL
THEN product_title

WHEN product_programname = 'ebay' AND product_programname IS NOT NULL
THEN product_title

WHEN product_programname = 'next' AND product_programname IS NOT NULL
THEN product_title

END
) as final_title

FROM products
GROUP BY model_number
Please assist how come it'll be possible.
Post Reply