diff options
| author | Andrey Andreev <narf@devilix.net> | 2016-02-17 18:19:56 +0100 |
|---|---|---|
| committer | Andrey Andreev <narf@devilix.net> | 2016-02-17 18:19:56 +0100 |
| commit | 86d2ec40b47f885a6d7e28b9dd519fac3332e7ae (patch) | |
| tree | 5267ecad8bc0ad56a87a4ed4094626a2589423e1 /user_guide_src/source/database/queries.rst | |
| parent | 82efb383544dc06aef7c628780b74acac31fb622 (diff) | |
[ci skip] Update docs to reflect escape_like_str() usage with ESCAPE '\!'
Closes #4462
Diffstat (limited to 'user_guide_src/source/database/queries.rst')
| -rw-r--r-- | user_guide_src/source/database/queries.rst | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/user_guide_src/source/database/queries.rst b/user_guide_src/source/database/queries.rst index 43a0a30bf..d4ffd16cf 100644 --- a/user_guide_src/source/database/queries.rst +++ b/user_guide_src/source/database/queries.rst @@ -123,7 +123,13 @@ this: $search = '20% raise'; $sql = "SELECT id FROM table WHERE column LIKE '%" . - $this->db->escape_like_str($search)."%'"; + $this->db->escape_like_str($search)."%' ESCAPE '!'"; + +.. important:: The ``escape_like_str()`` method uses '!' (exclamation mark) + to escape special characters for *LIKE* conditions. Because this + method escapes partial strings that you would wrap in quotes + yourself, it cannot automatically add the ``ESCAPE '!'`` + condition for you, and so you'll have to manually do that. ************** |