How to ignore null value while fetching the data from database table php mysql

Question

How to ignore null value while fetching the data from database table php mysql. Anyone please help me

My mysql query is :

$sql = "SELECT  DISTINCT cuid FROM temp_donor_list WHERE donor_no='$name'";

VinothRaja · Accepted Answer · 2018-11-30 05:59:32Z

1

Try this below code

$sql = "SELECT DISTINCT cuid FROM temp_donor_list WHERE donor_no='$name' and cuid!='' and donor_no!=''";

answered Nov 30, 2018 at 5:59

VinothRaja

1,4131 gold badge10 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

''(blank) is not equal to NULL. NULL is special value so you can not compare with blank string

This query executed correctly: $sql = "SELECT DISTINCT cuid FROM temp_donor_list WHERE donor_no='$name' AND cuid!=' '";

Sadikhasan · Accepted Answer · 2018-11-30 06:21:17Z

1

If your field contains NULL value then you can use IS NOT NULL condtion.
If your field contains blank string then you can use <> opertor

SELECT DISTINCT cuid FROM temp_donor_list WHERE donor_no='$name' AND cuid IS NOT NULL AND cuid<>''

answered Nov 30, 2018 at 5:59

Sadikhasan

18.6k23 gold badges85 silver badges126 bronze badges