Django ORM fuzzy query

Greater than >

• __gt

Greater than or equal to >=

• __gte

Be careful ： All the above are double underlined , What is written below is also double underlined

Less than <

• __lt

Less than or equal to <=

• __lte 

Exactly equal to like 'aaa'

• __exact

Exactly equal to Ignore case ilike 'aaa'

• __iexact 

contain like '%aaa%'

• __contains 

contain , Ignore case ilike '%aaa%', But for sqlite Come on ,contains The effect is the same as icontains.

• __icontains 

contain

• __in

It's empty

• __isnull 

With … start

• __startswith 

With … start Ignore case

• __istartswith 

With … ending

• __endswith 

With … ending , Ignore case

• __iendswith 

stay … Within the scope of

• __range 

The year of the date field

• __year 

The month of the date field

• __month 

Date of the date field

• __day 

It should be noted that , If you are using mysql, When using date query , Need to be in settings.py In the document USE_TZ  It is amended as follows USE_TZ = False