select a rounded float field

sakis · #1 (**permalink**) 11-18-09, 11:35

Hi

i am creating a price searching widget.

the price table has the fields
price , product_id

Sometimes the price is a long float for example 4,56889
I d like to return also this product_id when the user searches for 4,57.

so i need a where clause in which i can round the db price field.

I used "WHERE ROUND(price,2) =4,57" but it does not rounding the price.

Is there a way to do that ?

healdem · #2 (**permalink**) 11-18-09, 11:47

Code:

select my, column, list, ROUND(price,2) as RPrice from MyTable
where round(Price,2)  = 4.57;

seems to work for me

Internet Services

Web Development

Digital Marketing

Consumer Tech