Decimal comparison

I posted this in PHP apps but didn’t get much response. I have a MySQL column that holds prices, so decimals like 49.99 and 37.21… the datatype for the column is DECIMAL… when i do a comparison like SELECT * FROM table WHERE price < ‘50.01’; I get no results even though all 100 items in the database match this.

Am I missing something? Do I need to cast the variables or…?

Have you tried doing it without the apostrophes?

SELECT * FROM table WHERE price < 50.01

yeah… if I put (post_price < x) in parans it works, but not when i add it to the match / against…

I think if I use (post_price BETWEEN ‘x’ and ‘y’) it will work, but I am testing the accuracy of it now.