Added ability to _like paramater side to use 'none', in case one wants to query like instead of where without case being sensitive

chonthu · Phil Sturgeon · commit 74b648c2da3e · 2012-05-23T17:22:20.000+01:00
diff --git a/system/database/DB_active_rec.php b/system/database/DB_active_rec.php
@@ -660,8 +660,12 @@ protected function _like($field, $match = '', $type = 'AND ', $side = 'both', $n
 			$prefix = (count($this->ar_like) == 0) ? '' : $type;
 
 			$v = $this->escape_like_str($v);
-
-			if ($side == 'before')
+			
+			if ($side == 'none')
+			{
+				$like_statement = $prefix." $k $not LIKE '{$v}'";
+			}
+			elseif ($side == 'before')
 			{
 				$like_statement = $prefix." $k $not LIKE '%{$v}'";
 			}

Original file line number	Diff line number	Diff line change
`@@ -660,8 +660,12 @@ protected function _like($field, $match = '', $type = 'AND ', $side = 'both', $n`
`660`	`660`	`$prefix = (count($this->ar_like) == 0) ? '' : $type;`
`661`	`661`
`662`	`662`	`$v = $this->escape_like_str($v);`
`663`		`-`
`664`		`- if ($side == 'before')`
	`663`	`+`
	`664`	`+ if ($side == 'none')`
	`665`	`+ {`
	`666`	`+ $like_statement = $prefix." $k $not LIKE '{$v}'";`
	`667`	`+ }`
	`668`	`+ elseif ($side == 'before')`
`665`	`669`	`{`
`666`	`670`	`$like_statement = $prefix." $k $not LIKE '%{$v}'";`
`667`	`671`	`}`