Answers for "if statement in mysql select column is value not null"

if column value is null then in mysql

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

Posted by: Guest on November-05-2020

Code answers related to "if statement in mysql select column is value not null"