summaryrefslogtreecommitdiffstats
path: root/user_guide_src/source
diff options
context:
space:
mode:
authorAndrey Andreev <narf@devilix.net>2018-09-05 15:54:42 +0200
committerAndrey Andreev <narf@devilix.net>2018-09-05 15:55:16 +0200
commitc45018334eea1e0000a83c9e7d189093dbc6b032 (patch)
treed94318c94679d1d7786eeb711c8797150b126dc2 /user_guide_src/source
parentf1e13c0127d9ba2d6da722672401b92dd37780bb (diff)
[ci skip] Merge pull request #5583 from johndekroon/develop
Documented undocumented feature
Diffstat (limited to 'user_guide_src/source')
-rw-r--r--user_guide_src/source/database/query_builder.rst3
1 files changed, 2 insertions, 1 deletions
diff --git a/user_guide_src/source/database/query_builder.rst b/user_guide_src/source/database/query_builder.rst
index 38bc7fcff..3c72218cd 100644
--- a/user_guide_src/source/database/query_builder.rst
+++ b/user_guide_src/source/database/query_builder.rst
@@ -358,13 +358,14 @@ searches.
// WHERE `title` LIKE '%match%' ESCAPE '!' AND `body` LIKE '%match% ESCAPE '!'
If you want to control where the wildcard (%) is placed, you can use
- an optional third argument. Your options are 'before', 'after' and
+ an optional third argument. Your options are 'before', 'after', 'none' and
'both' (which is the default).
::
$this->db->like('title', 'match', 'before'); // Produces: WHERE `title` LIKE '%match' ESCAPE '!'
$this->db->like('title', 'match', 'after'); // Produces: WHERE `title` LIKE 'match%' ESCAPE '!'
+ $this->db->like('title', 'match', 'none'); // Produces: WHERE `title` LIKE 'match' ESCAPE '!'
$this->db->like('title', 'match', 'both'); // Produces: WHERE `title` LIKE '%match%' ESCAPE '!'
#. **Associative array method:**