mysql query if value is numeric

[mattm1712]

how can i do this?

 

mysql_query("SELECT * FROM prices WHERE price='NUMERIC' ")

 

i know NUMERIC wont work but im not sure how to do it

 

cheers matt

[Jessica]

What are you trying to do?

What is the data type of the field?

[mattm1712]

i have values like

 

12.2

14.5

-

1.2

0.3

-

-

12.0

 

i want to remove all the '-''s

[Jessica]

You want to remove the entire row, or change the - to something?

 

Once you figure out how you want to handle those rows, you'll want to change the column to be a decimal type.

[mattm1712]

i want to ignore them from my query

[Jessica]

You need to fix the data, so in the long term you have good data to work with. However, you can do != '-' for a quick fix.

[Psycho]

Yes, I am 100% in agreement with jesirose - your database schema is flawed. You should use a numeric type field to store the data. not sure what your intention of '-' is for. Do you interpret that as a 0.00 price or perhaps it means No Price? If you mean for that to be no price then you should change the field to a numeric type and allow nulls. Then set those fields to NULL.

 

You're creating more problems for yourself later by doing what you are currently doing.