select field(s) from myytable;

[Mohsen Pahlevanzadeh]

Hello everybody,

I can write a query with django if I have : "select * from mytable;"

But if I have a field , I can write, such as "select f1,f2 from mytable;"

Please help me.

[Klaus Laube]

I'm not sure if I got your question right, but I guess `values()` is what you are looking for: https://docs.djangoproject.com/en/3.0/ref/models/querysets/#values

From the documentation:

The values() method takes optional positional arguments, *fields, which specify field names to which the SELECT should be limited. If you specify the fields, each dictionary will contain only the field keys/values for the fields you specify. If you don’t specify the fields, each dictionary will contain a key and value for every field in the database table.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/dda9aa1f-6f6b-451a-84b6-626397d2d95f%40googlegroups.com.

[Muhammed Rafi A]

Mytable.objects.values('f1', 'f2')

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAE89-bdNrrXzPN%2BSO7TFiYhrfpaHdKotftJaJfVacFy7L6m1Nw%40mail.gmail.com.