summaryrefslogtreecommitdiff
path: root/docs/ref
diff options
context:
space:
mode:
authorLakshya <lakshya212001@gmail.com>2026-02-12 15:05:07 +0530
committerJacob Walls <jacobtylerwalls@gmail.com>2026-03-03 12:52:25 -0500
commit5b939808220fa879942303f4318276668d11b4d9 (patch)
tree4bf01b6a59eb8d9afe319d4dbcb79ac3e48bf9e9 /docs/ref
parent62ab467686845e2a12a2580997a81d4bf61edfc6 (diff)
Fixed #20775 -- Clarified that SQL for text lookups varies per database.
Diffstat (limited to 'docs/ref')
-rw-r--r--docs/ref/models/querysets.txt14
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