Mysql query neglect string, get integer value only in varchar column
by Jayanthi[ Edit ] 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.
