Alex Rivera | Logout

"WHERE column IS NOT NULL" with Kohana v3 Query Builder

Asked 2010-09-26T00:50:02.943
14

Is it possible with Kohana v3 Query Builder to use the IS NOT NULL operator?

The where($column, $op, $value) method requires all three parameters and even if I specify

->where('col', 'IS NOT NULL', '')

it builds and invalid query eg.

SELECT * FROM table WHERE col IS NOT NULL '';
Edit
Report

1 Answer

3

Not sure (it's 3 AM right now) but ->where('col', '', DB::expr('IS NOT NULL')) might works.

answered 2010-09-26T00:54:53.573

Your Answer