blocks|key|261853|text|使用__contains或__icontains+(不区分大小写)：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|261854|result+=+table.objects.filter(string__contains='pattern')|code-block|syntax|javascript|261855|SQL的等价物是|261856|SELECT+...+WHERE+string+LIKE+'%25pattern%25';|261857|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/stable/ref/models/querysets/#contains|1|https://docs.djangoproject.com/en/stable/ref/models/querysets/#icontains^0|2|A|D|B|2|A|0|D|B|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@$9|13|A|14|1|15]|$9|16|A|17|1|18]]|E|$]]|$1|F|3|G|5|H|7|19|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|1A|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|1B|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|1C|8|@]|D|@]|E|$]]]|P|$Q|$5|R|S|T|E|$U|V]]|W|$5|R|S|T|E|$U|X]]]]

Use <a href="https://docs.djangoproject.com/en/stable/ref/models/querysets/#contains" rel="noreferrer"><code>__contains</code></a> or <a href="https://docs.djangoproject.com/en/stable/ref/models/querysets/#icontains" rel="noreferrer"><code>__icontains</code></a> (case-insensitive):
<pre class="lang-py prettyprint-override"><code>result = table.objects.filter(string__contains='pattern')
</code></pre>
The SQL equivalent is
<pre><code>SELECT ... WHERE string LIKE '%pattern%';
</code></pre>

blocks|key|261884|text|falsetru提到的包含和图标使查询类似于SELECT+...+WHERE+headline+LIKE+'%25pattern%25|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|261885|除了它们之外，您可能还需要具有类似行为的这些命令：startswith、istartswith、endswith、iendswith|261886|制作|261887|SELECT+...+WHERE+headline+LIKE+'pattern%25|261888|或|261889|SELECT+...+WHERE+headline+LIKE+'%25pattern|261890|entityMap|0|LINK|mutability|MUTABLE|url|http://djbook.ru/rel1.8/ref/models/querysets.html#startswith|1|http://djbook.ru/rel1.8/ref/models/querysets.html#istartswith|2|http://djbook.ru/rel1.8/ref/models/querysets.html#endswith|3|http://djbook.ru/rel1.8/ref/models/querysets.html#iendswith^0|M|15|0|P|A|0|10|B|1|1C|8|2|1L|9|3|0|0|0|14|0|0|0|14|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|16|8|@]|D|@$9|17|A|18|1|19]|$9|1A|A|1B|1|1C]|$9|1D|A|1E|1|1F]|$9|1G|A|1H|1|1I]]|E|$]]|$1|H|3|I|5|6|7|1J|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|1K|8|@$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|L|3|M|5|6|7|1N|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|1O|8|@$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|P|3|-4|5|6|7|1R|8|@]|D|@]|E|$]]]|Q|$R|$5|S|T|U|E|$V|W]]|X|$5|S|T|U|E|$V|Y]]|Z|$5|S|T|U|E|$V|10]]|11|$5|S|T|U|E|$V|12]]]]

contains and icontains mentioned by falsetru make queries like <code>SELECT ... WHERE headline LIKE '%pattern%</code> 

Along with them, you might need these ones with similar behavior:
<a href="http://djbook.ru/rel1.8/ref/models/querysets.html#startswith" rel="noreferrer">startswith</a>, <a href="http://djbook.ru/rel1.8/ref/models/querysets.html#istartswith" rel="noreferrer">istartswith</a>, <a href="http://djbook.ru/rel1.8/ref/models/querysets.html#endswith" rel="noreferrer">endswith</a>, <a href="http://djbook.ru/rel1.8/ref/models/querysets.html#iendswith" rel="noreferrer">iendswith</a>

making 

<code>SELECT ... WHERE headline LIKE 'pattern%</code>

or

<code>SELECT ... WHERE headline LIKE '%pattern</code>

blocks|key|45396|text|这可以使用Django's+custom+lookups来完成。我已经在Django-like-lookup+application中进行了查找。安装它后，将启用带有%25和_通配符的__like查找。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|45397|应用程序中所有必需的代码是：|45398|from+django.db.models+import+Lookup
from+django.db.models.fields+import+Field


@Field.register_lookup
class+Like(Lookup):
++++lookup_name+=+'like'

++++def+as_sql(self,+compiler,+connection):
++++++++lhs,+lhs_params+=+self.process_lhs(compiler,+connection)
++++++++rhs,+rhs_params+=+self.process_rhs(compiler,+connection)
++++++++params+=+lhs_params+%2B+rhs_params
++++++++return+'%25s+LIKE+%25s'+%25+(lhs,+rhs),+params|code-block|syntax|javascript|45399|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.djangoproject.com/en/3.0/howto/custom-lookups/|1|https://github.com/PetrDlouhy/django-like-lookup^0|2B|1|2D|1|2I|6|5|N|0|10|U|1|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@$9|13|A|14|1|15]|$9|16|A|17|1|18]]|E|$]]|$1|F|3|G|5|6|7|19|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|1A|8|@]|D|@]|E|$K|L]]|$1|M|3|-4|5|6|7|1B|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]|U|$5|P|Q|R|E|$S|V]]]]

This can be done with <a href="https://docs.djangoproject.com/en/3.0/howto/custom-lookups/" rel="noreferrer">Django's custom lookups</a>. I have made the lookup into a <a href="https://github.com/PetrDlouhy/django-like-lookup" rel="noreferrer">Django-like-lookup application</a>. After installing it the <code>__like</code> lookup with the <code>%</code> and <code>_</code> wildcards will be enabled.

All the necessary code in the application is:

<pre><code>from django.db.models import Lookup
from django.db.models.fields import Field


@Field.register_lookup
class Like(Lookup):
 lookup_name = 'like'

 def as_sql(self, compiler, connection):
 lhs, lhs_params = self.process_lhs(compiler, connection)
 rhs, rhs_params = self.process_rhs(compiler, connection)
 params = lhs_params + rhs_params
 return '%s LIKE %s' % (lhs, rhs), params
</code></pre>

blocks|key|261909|text|result+=+table.objects.filter(string__icontains='pattern')|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|261910|不区分大小写搜索字段中的字符串。|unstyled|261911|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>result = table.objects.filter(string__icontains='pattern')
</code></pre>

Case insensitive search for string in a field.

blocks|key|261952|text|为了保持sql中类似'%25pattern%25‘语句的单词顺序，我使用了iregex，例如：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|261953|qs+=+table.objects.filter(string__iregex=pattern.replace('+',+'.*'))|code-block|syntax|javascript|261954|string方法是不可变的，所以您的pattern变量不会改变，使用.*时，您将查找除换行符以外的任何字符的0个或更多个匹配项。|261955|通过使用以下代码遍历模式单词：|261956|qs+=+table.objects
for+word+in+pattern.split('+'):
++++qs+=+qs.filter(string__icontains=word)|261957|您的模式中单词的顺序将不会被保留，对于某些人来说，这是可行的，但在尝试模仿sql+like语句的情况下，我将使用第一个选项。|261958|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

In order to preserve the order of the words as in the sql LIKE '%pattern%' statement I use iregex, for example:

<pre><code>qs = table.objects.filter(string__iregex=pattern.replace(' ', '.*'))
</code></pre>

string methods are immutable so your pattern variable will not change and with .* you'll be looking for 0 or more occurrences of any character but break lines.

By using the following to iterate over the pattern words: 

<pre><code>qs = table.objects
for word in pattern.split(' '):
 qs = qs.filter(string__icontains=word)
</code></pre>

the order of the words in your pattern will not be preserved, for some people that could work but in the case of trying to mimic the sql like statement I'll use the first option.

blocks|key|262020|text|完整的示例:假设我们有一个名为DjangTable的表，其中的字符串字段名为file_name，我们希望创建与mysql中字符串file_name中的空格匹配的查询等价的Django+filter：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|262021|SELECT+*+FROM+DjangTable+WHERE+file_name+LIKE+'%25+%25'+
class+DjangTable(UTModel):


++++...
++++file_name+=+models.CharField(max_length=255,+null=False)
++++...|code-block|syntax|javascript|262022|在使用python的Django中，它将是：|262023|pattern+=+'+'+#+same+as+mysql+LIKE+'%25+%25'
DjangTable.objects.filter(file_name__contains=pattern)|262024|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

full example : lets say we have table called DjangTable with string field name file_name and we want to create Django filter equivalent to the query that match space in the string file_name in mysql:
<pre><code>SELECT * FROM DjangTable WHERE file_name LIKE '% %' 
class DjangTable(UTModel):


 ...
 file_name = models.CharField(max_length=255, null=False)
 ...
</code></pre>
in Django using python it will be :
<pre><code>pattern = ' ' # same as mysql LIKE '% %'
DjangTable.objects.filter(file_name__contains=pattern)
</code></pre>

What is the equivalent of this SQL statement in django?

<pre><code>SELECT * FROM table_name WHERE string LIKE pattern;
</code></pre>

How do I implement this in django? I tried

<pre><code>result = table.objects.filter( pattern in string )
</code></pre>

But that did not work. How do i implement this?

sql "LIKE" equivalent in django query

Django

在django中，这条SQL语句的等价物是什么？SELECT * FROM table_name WHERE string LIKE pattern;如何在django中实现这一点？我试过了result = table.objects.filter( pattern in string )但这并不管用。我如何实现这一点？

问django查询中的sql "LIKE“等效项
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问django查询中的sql "LIKE“等效项EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问django查询中的sql "LIKE“等效项
EN