MYSQL hide field data if value in another field is set

Question

Got a table like:

art.    type    price
a        b       1
a        c       2

would it be possible with a select to show filtered content as:

art.    type    price
a        b       
a        c       2

so that if the type is "b" don't show price data?

select art, type, price from x 
where type="b" hide price

what is the condition that decide if a field should be hidden or not? — MrSimpleMind, Sep 06 '13 at 13:32

score 1 · Accepted Answer · answered Sep 06 '13 at 13:31

Logic of this sort probably best belongs in the presentation, rather than database, layer of your application. However, it is nevertheless possible using either MySQL's IF() function or its CASE expression—for example:

SELECT art, type, IF(type='b',NULL,price) price FROM x;

See it on sqlfiddle.

MYSQL hide field data if value in another field is set

1 Answers1

Linked