From e54e3d2786b76266e6b6dde481cc493ba002faae Mon Sep 17 00:00:00 2001
From: Derek Allard
// Produces: AND WHERE username IN ('Frank', 'Todd', 'James')
Generates a WHERE field IN ('item', 'item') SQL query joined with OR if appropriate
$names = array('Frank', 'Todd', 'James');
@@ -288,7 +287,7 @@ $this->db->or_where('id >', $id);
$this->db->where_not_in('username', $names);
// Produces: AND WHERE username NOT IN ('Frank', 'Todd', 'James')
Generates a WHERE field NOT IN ('item', 'item') SQL query joined with OR if appropriate
This function is identical to the one above, except that multiple instances are joined by OR: Note: or_like() was formerly known as orlike(), which has been deprecated. This function is identical to like(), except that it generates NOT LIKE statements: This function is identical to not_like(), except that multiple instances are joined by OR: Permits you to write the GROUP BY portion of your query:
$names = array('Frank', 'Todd', 'James');
@@ -338,7 +337,7 @@ $this->db->or_where('id >', $id);
-$this->db->like('title', $match);
@@ -347,6 +346,17 @@ $this->db->or_like('body', $match);
+$this->db->like('title', 'match');
$this->db->or_like('body', $match);
// WHERE title LIKE '%match%' OR body LIKE '%match%'$this->db->not_like();
+ $this->db->not_like('title', 'match');
+
+
+// WHERE title NOT LIKE '%match%$this->db->or_not_like();
+ $this->db->like('title', 'match');
+$this->db->or_not_like('body', 'match');
+
+// WHERE title LIKE '%match% OR body NOT LIKE 'match'$this->db->group_by();