如何查询哪里可以过滤Django中以数字开头的所有内容? [英] How do I make a query where it filters everything that starts with a number in Django?
本文介绍了如何查询哪里可以过滤Django中以数字开头的所有内容?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
class Book(models.Model):
title = models.CharField(null = False,blank = False)
现在我需要一个过滤器来获取所有书籍的头衔以数字开头。
这样做,但是如何扩展查询集?
b = Book.objects.filter(title__startswith = 1).order_by('title')
这不工作
b = b + Book.objects.filter(title__startswith = 2)。 order_by('title')
或此
b.extend(Book.objects.filter(title__startswith = 2).order_by('title'))
解决方案
您可以使用正则表达式作为查询参数:
Book.objects.filter(title__regex = r' \\ D)
I have a model called Book with a Title Field.
class Book(models.Model):
title = models.CharField(null = False,blank=False)
Now I need a filter to get all books with titles starting with a number.
This works but how will I extend the queryset?
b = Book.objects.filter(title__startswith = 1).order_by('title')
This doesn't work
b = b + Book.objects.filter(title__startswith = 2).order_by('title')
or this
b.extend(Book.objects.filter(title__startswith = 2).order_by('title'))
解决方案
You can use a regular expression as a query parameter:
Book.objects.filter(title__regex=r'\d')
这篇关于如何查询哪里可以过滤Django中以数字开头的所有内容?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文