From c0c9ebf077e23b18bf94225154671feab1369466 Mon Sep 17 00:00:00 2001 From: John de Kroon Date: Mon, 3 Sep 2018 11:24:45 +0200 Subject: Documented undocumented feature The 'none' option is a valid option, which was documented in the 2.x documentation. I added it since it is still supported in 3.x. --- user_guide_src/source/database/query_builder.rst | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'user_guide_src/source/database') diff --git a/user_guide_src/source/database/query_builder.rst b/user_guide_src/source/database/query_builder.rst index 860b34d4c..a33c7073b 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:** -- cgit v1.2.3-24-g4f1b