A MySQL IF condition

Question

In my query I have an IF statement:

IF(friend.block, 'yes', 'no')

where friend.block value is 0 or 1.. but either way its putting 'yes'.. any idea?

what is the type of friend.block?

user180100
– user180100

2009-10-12 12:35:56 +00:00
Commented Oct 12, 2009 at 12:35 — user180100
– user180100, Commented Oct 12, 2009 at 12:35

Kanishka Panamaldeniya · Accepted Answer · 2012-07-06 11:57:51Z

7

friend.block should be of type INTEGER for that to work or you have to put a comparaison there:

IF(friend.block != 0, 'yes', 'no')

edited Jul 6, 2012 at 11:57

Kanishka Panamaldeniya

17.6k31 gold badges128 silver badges195 bronze badges

answered Oct 12, 2009 at 12:36

manji

48k5 gold badges98 silver badges104 bronze badges

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

Comments

Kirtan · Accepted Answer · 2009-10-12 12:34:43Z

3

Reference: MySQL Reference

The syntax is:

IF (friend.block = 1) THEN
    'Yes'
ELSE
    'No'
END IF

You can use case statement:

CASE friend.block WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END

answered Oct 12, 2009 at 12:34

Kirtan

21.7k6 gold badges50 silver badges61 bronze badges

1 Comment

Andre Miller Over a year ago

Still doesn't explain why his if function didn't work, see: dev.mysql.com/doc/refman/5.0/en/…

Zed · Accepted Answer · 2009-10-12 12:33:09Z

0

CASE friend.block WHEN 1 THEN 'yes' WHEN 0 THEN 'no' END

answered Oct 12, 2009 at 12:33

Zed

57.8k9 gold badges79 silver badges101 bronze badges

Collectives™ on Stack Overflow

A MySQL IF condition

3 Answers 3

Comments

Reference: MySQL Reference

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Reference: MySQL Reference

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related