Merge pull request #3198 from ivantcholakov/feature/is-not-null

Query builder: IS NOT NULL support implementation, see #3194

1 files changed, 9 insertions, 0 deletions

diff --git a/system/database/DB_query_builder.php b/system/database/DB_query_builder.php
index 085c615e5..69dc8c2d1 100644
--- a/system/database/DB_query_builder.php
+++ b/system/database/DB_query_builder.php
@@ -661,6 +661,15 @@ abstract class CI_DB_query_builder extends CI_DB_driver {
 				// value appears not to have been set, assign the test to IS NULL
 				$k .= ' IS NULL';
 			}
+			else
+			{
+				$operator = trim($this->_get_operator($k));
+
+				if ($operator === '<>' OR $operator === '!=')
+				{
+					$k = str_replace($operator, ' IS NOT NULL', $k);
+				}
+			}
 
 			$this->{$qb_key}[] = array('condition' => $prefix.$k.$v, 'escape' => $escape);
 			if ($this->qb_caching === TRUE)