MySQL Forums
Forum List  »  Newbie

Set a field same as another
Posted by: Gary Corcoran
Date: May 06, 2016 04:03AM

Hi

I want to run a query that will look at the price in one column and set another column a rounded price ie: if column A (the price column) is 2.95 I want to set another column 3 if the price is 2.25 I want to set the other column to 2 is this poss please? in other words the nearer to the whole value and I would it at that.. is it a brain teaser?

Options: ReplyQuote


Subject
Written By
Posted
Set a field same as another
May 06, 2016 04:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.