ansaurus

Question

mysql if condition

Answer 1

A:

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

Zed 2009-10-12 12:33:09

Answer 2

A:

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

Kirtan 2009-10-12 12:34:43

Still doesn't explain why his if function didn't work, see: http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_if

Andre Miller 2009-10-12 12:36:34

Answer 3

A:

if(friend.block > '0', 'yes', 'no') :) thanks everyone

Basit 2009-10-12 12:35:40

Answer 4

+3 A:

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)

najmeddine 2009-10-12 12:36:21