query help

[Anon]

First, I am new to php and MySQL. Now, I have a text file (comma delimited, and fields are enclosed by quotes) that I import into a MySQL table. One field is a number with a format of 12,345. I am trying to use a query to search for all records between two values input from a user. (using >= and <=) This will not work on a column type of text but if I switch to INT it will change the field value to 12 instead of 12,345. If anyone could steer me in the right direction to get this accomplished i would appreciate it. Thanks in advance.

[tomhath]

I would strip the commas out and convert the column to an int. Both mysql has adequate string manipulating functions built in, there are many ways to do it. Take a look at mysql's LOCATE, INSTR, POSITION, SUBSTRING, and CONVERT functions.