Merhaba pLusWeb,

Sana olan tavsiyem : IFNULL() kullanmaktir.

Ornek:

tablo yapalim:

CREATE TABLE IF NOT EXISTS contacts(
    contactid INT(4) AUTO_INCREMENT PRIMARY KEY,
    contactname varchar(20) NOT NULL,
    bizphone varchar(15),
    homephone varchar(15)
)ENGINE=InnoDB;

elemanlar elave edelim:

INSERT INTO contacts(contactname,bizphone,homephone)
VALUES('John Doe','(541) 754-3009',NULL),
      ('Cindy Smith',NULL,'(541) 754-3110'),
      ('Sue Greenspan','(541) 754-3010','(541) 754-3011'),
      ('Lily Bush',NULL,'(541) 754-3111');

simdi bu degerleri alalim:

SELECT contactname,
       IFNULL(bizphone,homephone) phone
FROM contacts;

gelen cevap bu olucak: