You want to not store money values with a dollar sign. Doing so will negate the benefit of being able to do mathematical operations in your queries and make uneccessary work for PHP. Store them as decimal instead of having PHP remove the dollar sign, do the math, and add the dollar sign back on.