Data comparisons and commas

[mwdavis23]

Is there a data type in MySQL that supports commas when doing a comparison? I have tried returning a list of results from a comparison I did on a list of prices I have in a database, and the prices have commas to seperate that numbers after $1,000 and decimal places for cents, but I have the data type set as a varchar right now and the comparison is only comparing the numbers before the first comma. I want to be able to compare all the data in the field, i.e. commas and all. Is there a way to do this, or is it more trouble than it's worth?

Thanks,
Matt Davis

[tomhath]

Sounds like more trouble than its worth. I'd store the prices as decimal type instead of characters. Then use php printf to format the price when you want to display it.