Remove Null Values from MYSQL during select

Question

I have a survey form which records multiple responses in a MYSQL table and each member can refer to a different member in a different response or choose not to which will then be set as NULL as the table below.

membername-----referralto
Mike  -------- NULL
Ali  --------  NULL 
Mike  -------  Jack  
Ali  --------  Jill

I want the names of members and who the referrals were for. So here's what i tried;

SELECT membername, referralto 
FROM responses

This query returns me the NULL Values in the referralto fields as well. Is there a way i can filter out the NULL Values? I even tried this as well but it didn't work.

SELECT membername, NULLIF( referralto, '' )  AS member 
FROM responses

Thank you.

Answer 1

Have you tried just adding "where referralto is not null"?

SELECT membername, NULLIF( referralto, '' )  AS member 
FROM responses
WHERE referralto IS NOT NULL