How do I change all greater than .00 cents to .49 cents be .00 and all greater than .50 to be round off?

I'm using SqlYog btw.

price 1: 16:03
price 2: 16:53

price 1: 16:00
price 2: 17:00

Recommended Answers

All 2 Replies

I tried using round its not changing '0 affected rows'

update product set price1 = round(price1,2);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.