CODEWITHSUNDEEP
phpmysql
Ahmad
Ahmad

Reputation: 359

Remove Null Values from MYSQL during select

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.

Upvotes: 3

Views: 11121

Answers (3)

Henry ramirez
Henry ramirez

Reputation: 1

GROUP BY, was my best solution on my case.

Upvotes: 0

Amarnasan
Amarnasan

Reputation: 15579

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

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

Upvotes: 4

Niranjan N Raju
Niranjan N Raju

Reputation: 11987

Use group by

SELECT membername,referralto  AS member 
FROM responses
GROUP BY membername

Upvotes: 0

Related Questions