Prices (Decimals)

[XpertWorlock]

Hi, I have a column that contains prices, the type of the column is "Decimal(16,2)".

 

I'm having a problem querying when a price should be above a certain level.

 

Ex.

 

Select * FROM table WHERE price > '500.00'

 

I'm assuming I have to change the query a little bit.

[petroz]

I just ran a little test on a similar environment with a decimal formatted column.

 

 

SELECT * FROM `order_styles` WHERE `sp` > '600.00'

 

This worked fine for me.

 

[XpertWorlock]

It was my fault, a mod_rewrite problem I had with query string.

 

Thanks for taking the time to reply

[Mchl]

The field is a numeric datatype, so do not put the price in quotes. This is slowing down (a little, but still) your query.

SELECT * FROM `order_styles` WHERE `sp` > 600