In mysql query while cast decimal value it show different values

Question

My Query is as follows

SELECT *
  FROM orders 
 WHERE ODR_ID ='3573' 
   AND CAST(WIDTH AS DECIMAL) = CAST('1.500' AS DECIMAL) 
   AND CAST(BREADTH AS DECIMAL) = CAST('0.500' AS DECIMAL) 
 ORDER 
    BY ID DESC 

but result is as follows

question from:https://stackoverflow.com/questions/65932445/in-mysql-query-while-cast-decimal-value-it-show-different-values

Answer 1

Your cast is appled to tew filter (where condition) not to the output (select clause)

so try

SELECT CAST(WIDTH AS DECIMAL) W, CAST(BREADTH AS DECIMAL) B
  FROM orders 
 WHERE ODR_ID ='3573' 
   AND CAST(WIDTH AS DECIMAL) = CAST('1.500' AS DECIMAL) 
   AND CAST(BREADTH AS DECIMAL) = CAST('0.500' AS DECIMAL) 
 ORDER 
    BY ID DESC