diff options
author | Nithin <admin@nitmedia.com> | 2011-08-21 06:23:47 +0200 |
---|---|---|
committer | Nithin <admin@nitmedia.com> | 2011-08-21 06:23:47 +0200 |
commit | ea4ad9b4e7ab7824da4274e30075fd36a6bf9952 (patch) | |
tree | 18f75652f6c9bf9b33c85b8b0e1d59c3d369d875 | |
parent | 9aa8929858de7486fce76415e1ab722f4d5e90ab (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.php | 8 |
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}'"; } |