$this->db->where('field !=', 1); when default is null in codeigniter

Question

when i use $this->db->where('field !=', 1);

i want to select all entries where field is not 1. so that means here 0 or NULL however in codeigniter he doesn't select it where the entry is NULL (default value).

how to solve this without changing the database?

dave

Yan Berk · Accepted Answer · 2013-11-15 15:41:42Z

2

NULL values need to be handled separately with another where clause:

$this->db->where('field <>', 1)->or_where('field IS NULL', NULL);

It has nothing to do with Codeigniter. It's a MySQL matter.

answered Nov 15, 2013 at 15:41

Yan Berk

14.5k9 gold badges58 silver badges52 bronze badges

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

1 Comment

Dave Driesmans Over a year ago

thanks! actually had to do it this way $this->db->where("(field != 1 OR field IS NULL)"); because of the OR. there should be a cleaner way in codeigniter but don't think there is one.

Collectives™ on Stack Overflow

$this->db->where('field !=', 1); when default is null in codeigniter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related