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…?