diff options
author | Nithin <admin@nitmedia.com> | 2011-08-21 06:23:47 +0200 |
---|---|---|
committer | Phil Sturgeon <email@philsturgeon.co.uk> | 2012-05-23 18:22:20 +0200 |
commit | 74b648c2da3ee5d92920cea2355ccf36d5e0519e (patch) | |
tree | 2995797166d4aa13605f733885d22ffbb05e9160 | |
parent | a3ce0ec96f98e1bcd1c5a0bc088d13f3178c01c6 (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}'"; } |