MySQL Query returns string instead of numeric value

Question

I want to multiply 4 with number of faults if faulttype='business' and faultseverity='fatal', using query listed below;

Select faulttype, IF (faulttype='business' AND faultseverity='fatal', 1,0)* 4 FROM tbl_fault WHERE product='DAS' AND faultdistribution='missed'
 group by faulttype

I am getting result business instead of numeric value, What should be corrected in this query?

Regards

Which column of your result set are you trying to retrieve? The first is still faulttype, the second will be the numeric value. — Guillaume Poussel
– Guillaume Poussel, Commented Oct 8, 2013 at 6:09
Yes, but you should show us the code, not the query. The problem must be there. — Guillaume Poussel
– Guillaume Poussel, Commented Oct 8, 2013 at 6:13
$cmsc= mysql_query("Select faulttype, IF (faulttype='business' AND faultseverity='fatal', 1,0)* 4 FROM tbl_fault WHERE product='DAS' AND faultdistribution='missed' group by faulttype"); while ($cresult = mysql_fetch_array ($cmsc)) $fat[0] = $cresult[0]; — MOZ
– MOZ, Commented Oct 8, 2013 at 6:13
$cresult[0]: the first index is the first column. Use $cresult[1] for the second column. — Guillaume Poussel
– Guillaume Poussel, Commented Oct 8, 2013 at 6:15

Krishna Rani Sahoo · Accepted Answer · 2013-10-08 06:40:23Z

2

try this

Select faulttype, sum(IF (faulttype='business' AND faultseverity='fatal', 1,0))*4 FROM tbl_fault WHERE product='DAS' AND faultdistribution='missed'
 group by faulttype;

For reference see the sql fiddle.

answered Oct 8, 2013 at 6:40

Krishna Rani Sahoo

1,5391 gold badge15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

OZIE · Accepted Answer · 2013-10-08 06:35:33Z

1

Try this

Select CASE faulttype WHEN faulttype='business' AND faultseverity='fatal' THEN 1*4 ELSE 0 END AS rez FROM tbl_fault WHERE product='DAS' AND faultdistribution='missed'

answered Oct 8, 2013 at 6:35

OZIE

1579 bronze badges

Collectives™ on Stack Overflow

MySQL Query returns string instead of numeric value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related