SQL - Hide Prices where decimal fields are 0

22-06-2013 01:15PM #1

Guys....doing a favour for a friend and he needs a MySQL database with products and two different prices.

Price A has prices on every product while
Price B only applies to some products as an alternative size.

How can I hide results of this column where the price is 0.00.

thanks

SalteeDog · 22-06-2013 02:17PM

If it was Oracle you could use a 'Decode' function. Perhaps in MySQL it's CASE or IF.

22-06-2013 02:57PM

Thanks for that SalteeDog

Tried a lot of Case examples now with no luck.

MySQL database is db1 and has
product_id
product_name
product_photo
price_1
price_2

I want to show product_id, product_name and price_1 under product_photo.
I also want price_2 to appear under each product but only show if the price isn't 0.

Any examples I see deal with records and not cells or values themselves.

dalta5billion · 22-06-2013 05:44PM

EIREHotspur wrote: »

Thanks for that SalteeDog

Tried a lot of Case examples now with no luck.

MySQL database is db1 and has
product_id
product_name
product_photo
price_1
price_2

I want to show product_id, product_name and price_1 under product_photo.
I also want price_2 to appear under each product but only show if the price isn't 0.

Any examples I see deal with records and not cells or values themselves.

How are you displaying the data? Could you filter there? (E.g. PHP or something?)

amen · 22-06-2013 08:48PM

Does the following work ? I'm not a MySQL guy
[PHP]

SELECT
product_id,
product_name,
product_photo,
price_1,
CASE
WHEN price_2 =0 THEN NULL
ELSE price_2
END
FROM
mytable

[/PHP]

23-06-2013 11:55AM

amen wrote: »

Does the following work ? I'm not a MySQL guy
[PHP]

SELECT
product_id,
product_name,
product_photo,
price_1,
CASE
WHEN price_2 =0 THEN NULL
ELSE price_2
END
FROM
mytable

[/PHP]

Thanks lads...I am going to test out this amen and will tell you if it works.

SQL - Hide Prices where decimal fields are 0

Comments