How do I query for this in Django?

Question

| random_code         | varchar(200)  | YES  | UNI | NULL    |                |

MyTable.objects.filter(random_code = None)

Is this correct? Will this SELECT where there is no random code set? Above is my table.

possible duplicate of [Filtering for empty or NULL names in a queryset](http://stackoverflow.com/questions/844556/filtering-for-empty-or-null-names-in-a-queryset) — Ismael, Apr 20 '14 at 08:06

score 1 · Answer 1 · answered May 08 '10 at 00:18

1

If you ever want to see what your QuerySet as SQL you can use QuerySet.query.as_sql() to return the SQL statement as a string.

answered May 08 '10 at 00:18

Zach

score 1 · Answer 2 · edited May 23 '17 at 10:33

1

This has been asked here. Basically you do this:

MyTable.objects.filter(random_code__isnull=True)

edited May 23 '17 at 10:33

Community

answered May 08 '10 at 02:20

Jason Webb

score 1 · Answer 3 · answered Aug 12 '20 at 08:34

1

In addition of Jason Webb's answer you could do something like:

MyTable.objects.filter(random_code__isnull=True).exclude(random_code='')

to exclude variants which have empty string.

answered Aug 12 '20 at 08:34

Timur Kapitonov

3 Answers3