How to check the null value fields using MySQL Query?

Question

I have a table name users. This table having 25 columns.

After login i have updated some fields. Now i want to know how many column is blank(null value).

It is not possible to use if...elseif...else condition. Is there any single query to get the all null value fields?

Please write your answer

Thanks

EDIT:

Code:

$getUser=mysql_fetch_array(mysql_query("SELECT * FROM users"));
if($getUser['field1']==''){
    //field1 is blank
}elseif($getUser['field2']==''){
    //field2 is blank
}elseif($getUser['field3']==''){
    //field3 is blank
}
.
.
.
elseif($getUser['field25']==''){
    //field25 is blank
}

Please write your attempt

Bryan
– Bryan

2014-05-02 05:57:48 +00:00
Commented May 2, 2014 at 5:57 — Bryan
– Bryan, Commented May 2, 2014 at 5:57
Hi i have update my question Please check.

Developer
– Developer

2014-05-02 06:24:58 +00:00
Commented May 2, 2014 at 6:24 — Developer
– Developer, Commented May 2, 2014 at 6:24
possible duplicate of MySQL SELECT only not null values

SagarPPanchal
– SagarPPanchal

2014-05-02 06:38:36 +00:00
Commented May 2, 2014 at 6:38 — SagarPPanchal
– SagarPPanchal, Commented May 2, 2014 at 6:38

Zafar Malik · Accepted Answer · 2014-05-02 05:58:22Z

2

use below query:

select * from mytable 
where field1 is null or field2 is null or .....field25 is null;

answered May 2, 2014 at 5:58

Zafar Malik

6,8723 gold badges23 silver badges31 bronze badges

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

1 Comment

Chinmay235 Over a year ago

Your query is working fine. Suppose i have 200 columns now how to write that query? It is not possible to write field1 is null or field2 is null.....field200 is null Is there any shortcut query?

Hieu Vo · Accepted Answer · 2014-05-02 06:47:57Z

1

$users=mysql_fetch_array(mysql_query("SELECT * FROM users"));

foreach ($users as $user) {
    $count = 0;
    foreach ($user as $column_name => $column) {
        if ($column == '')
            $count++;
    }

    echo $count."\n";
}

if you want to get more information about which column is null, you can echo $column_name

answered May 2, 2014 at 6:47

Hieu Vo

3,3441 gold badge32 silver badges32 bronze badges

Comments

Bla... · Accepted Answer · 2014-05-02 05:59:53Z

-1

To get a row with a null column you can use this query:

SELECT LastName,FirstName,Address FROM Users
WHERE Address IS NULL

If you want to know how many column is blank(null value), it will be better if you SELECT * that spesific-user and check the result through php..

answered May 2, 2014 at 5:59

Bla...

7,2887 gold badges29 silver badges47 bronze badges

Collectives™ on Stack Overflow

How to check the null value fields using MySQL Query?

3 Answers 3

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Linked

Related