summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorNithin <admin@nitmedia.com>2011-08-21 06:23:47 +0200
committerNithin <admin@nitmedia.com>2011-08-21 06:23:47 +0200
commitea4ad9b4e7ab7824da4274e30075fd36a6bf9952 (patch)
tree18f75652f6c9bf9b33c85b8b0e1d59c3d369d875
parent9aa8929858de7486fce76415e1ab722f4d5e90ab (diff)
Added ability to _like paramater side to use 'none', in case one wants to query like instead of where without case being sensitive
-rw-r--r--system/database/DB_active_rec.php8
1 files changed, 6 insertions, 2 deletions
diff --git a/system/database/DB_active_rec.php b/system/database/DB_active_rec.php
index 7bab729f5..841ede28e 100644
--- a/system/database/DB_active_rec.php
+++ b/system/database/DB_active_rec.php
@@ -660,8 +660,12 @@ class CI_DB_active_record extends CI_DB_driver {
$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}'";
}