diff options
| author | Lakshya <lakshya212001@gmail.com> | 2026-02-12 15:05:07 +0530 |
|---|---|---|
| committer | Jacob Walls <jacobtylerwalls@gmail.com> | 2026-03-03 12:52:25 -0500 |
| commit | 5b939808220fa879942303f4318276668d11b4d9 (patch) | |
| tree | 4bf01b6a59eb8d9afe319d4dbcb79ac3e48bf9e9 /docs | |
| parent | 62ab467686845e2a12a2580997a81d4bf61edfc6 (diff) | |
Fixed #20775 -- Clarified that SQL for text lookups varies per database.
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/ref/models/querysets.txt | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/docs/ref/models/querysets.txt b/docs/ref/models/querysets.txt index cc264a4e51..9ec45653de 100644 --- a/docs/ref/models/querysets.txt +++ b/docs/ref/models/querysets.txt @@ -3275,6 +3275,8 @@ SQL equivalent: SELECT ... WHERE headline LIKE '%Lennon%'; +(The exact SQL syntax varies for each database engine.) + Note this will match the headline ``'Lennon honored today'`` but not ``'lennon honored today'``. @@ -3302,6 +3304,8 @@ SQL equivalent: SELECT ... WHERE headline ILIKE '%Lennon%'; +(The exact SQL syntax varies for each database engine.) + .. admonition:: SQLite users When using the SQLite backend and non-ASCII strings, bear in mind the @@ -3427,6 +3431,8 @@ SQL equivalent: SELECT ... WHERE headline LIKE 'Lennon%'; +(The exact SQL syntax varies for each database engine.) + SQLite doesn't support case-sensitive ``LIKE`` statements; ``startswith`` acts like ``istartswith`` for SQLite. @@ -3447,6 +3453,8 @@ SQL equivalent: SELECT ... WHERE headline ILIKE 'Lennon%'; +(The exact SQL syntax varies for each database engine.) + .. admonition:: SQLite users When using the SQLite backend and non-ASCII strings, bear in mind the @@ -3469,6 +3477,8 @@ SQL equivalent: SELECT ... WHERE headline LIKE '%Lennon'; +(The exact SQL syntax varies for each database engine.) + .. admonition:: SQLite users SQLite doesn't support case-sensitive ``LIKE`` statements; ``endswith`` @@ -3490,7 +3500,9 @@ SQL equivalent: .. code-block:: sql - SELECT ... WHERE headline ILIKE '%Lennon' + SELECT ... WHERE headline ILIKE '%Lennon'; + +(The exact SQL syntax varies for each database engine.) .. admonition:: SQLite users |
