summaryrefslogtreecommitdiff
path: root/program/include/rcube_db.php
diff options
context:
space:
mode:
Diffstat (limited to 'program/include/rcube_db.php')
-rw-r--r--program/include/rcube_db.php20
1 files changed, 20 insertions, 0 deletions
diff --git a/program/include/rcube_db.php b/program/include/rcube_db.php
index 8fa34e6a5..716e0d9bf 100644
--- a/program/include/rcube_db.php
+++ b/program/include/rcube_db.php
@@ -511,6 +511,26 @@ class rcube_db
/**
+ * Return SQL statement for case insensitive LIKE
+ *
+ * @param string Field name
+ * @param string Search value
+ * @return string SQL statement to use in query
+ * @access public
+ */
+ function ilike($column, $value)
+ {
+ switch($this->db_provider)
+ {
+ case 'pgsql':
+ return $this->quote_identifier($column).' ILIKE '.$this->quote($value);
+ default:
+ return $this->quote_identifier($column).' LIKE '.$this->quote($value);
+ }
+ }
+
+
+ /**
* Adds a query result and returns a handle ID
*
* @param object Query handle