Mysql query neglect string, get integer value only in varchar column

by Jayanthi 2012-12-10 17:13:10

Mysql query neglect string, get integer value only in varchar column

1. Price column is varchar

2. Price column have string & numeric values.

3. Get only numeric values in price column.

String value will be "0".


SELECT CAST( price AS UNSIGNEDINTEGER ) price
FROM 'product'
ORDER BY price DESC


4. Numeric values have displayed original values from price column.

Tagged in:

881
like
0
dislike
0
mail
flag

You must LOGIN to add comments