CASE statement in sql

Question

I have a table containing these values:

object particular ----------------------- AD hammer AD stone PD nail PR rocket OBR trophy

by using a CASE statement how can I select both AD and PD ? Here's what I did:

object = CASE WHEN 'PD' OR 'AD' THEN 'PD' AND 'AD' ELSE 'OBR' END

I know this is wrong, could someone point me in the right direction?

Don't you just want to SELECT object, particular from <tablename> where object = 'AD' OR object = 'PD'? — René Vogt
– René Vogt, Commented May 15, 2016 at 11:36
i just want to know how can i do it using the case statement when the parameter = true then it will display both values from like AD and PD :) — yoyie yoyie
– yoyie yoyie, Commented May 15, 2016 at 11:43
So if we understood correctly, you just want to select the rows from the table where object is AD or PD. Correct? — shadow
– shadow, Commented May 15, 2016 at 11:55
yups..i want to display both data from AD and PD..by using case statement :) — yoyie yoyie
– yoyie yoyie, Commented May 15, 2016 at 12:08

Anthony E · Accepted Answer · 2016-05-15 11:36:50Z

2

Why can't you just use an OR condition in your select?

SELECT object FROM table_name WHERE object = 'AD' OR object = 'PD'

answered May 15, 2016 at 11:36

11.3k2 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Naman · Accepted Answer · 2016-05-15 11:37:46Z

1

Is this what you are looking for :

SELECT CASE WHEN object = 'AD' or object = 'PD' THEN ... ELSE ... END AS <newColumnName> FROM <table>

answered May 15, 2016 at 11:37

32.7k32 gold badges240 silver badges385 bronze badges

after the THEN keyword..i put 'PD' and 'AD'..and it gives me error..is that even possible ? :)

@yoyieyoyie - you need to put the entire implementation into the question for us to look into it

jelliaes · Accepted Answer · 2016-05-16 08:01:19Z

object = CASE WHEN 'PD' OR 'AD' THEN 'PD' AND 'AD' ELSE 'OBR' END

CORRECT SYNTAX: CASE WHEN <condition> THEN <value1> ELSE <value2> END

You have an incorrect syntax in the higlighted part