Null Values MySQL

Question

What is the best way to handle NULL values in a search form. I want to allow the user to search by 8 different criteria however if they leave a box blank I would like it to return all non null values for that column. I am able to assign a default value if the field is left blank but how can I change accountant to "IS NOT NULL"? Thank you for your time.

    if ($specialty_name == null){
        $specialty_name = 'Accountant';
    }

The SQL looks like this... WHERE specialty_name = 'Accountant'

Barmar · Accepted Answer · 2014-10-17 01:39:53Z

3

Something like this:

if ($specialty_name == null) {
    $where = "WHERE specialty_name IS NOT NULL";
} else {
    $where = "WHERE specialty_name = '$specialty_name'";
}

answered Oct 17, 2014 at 1:39

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

Null Values MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related