I'm fairly new to php and mysql and I'm trying to search a column in my mysql database that contains prices, with commas and decimal places, but is of type varchar. Is there a way to compare the data in this colum with a greater than or equals comparison? The way I have tried this is like this:
SELECT * FROM listing WHERE Price >= 100000 AND Type='Something'
Like I said above, the prices will have commas and decimal places, such as 192,569.00.
It seems to work randomly...it will display some results that are true but others that shouldn't be there. Thanks.
Matt Davis
