获取在Django中找到搜索值的列名

from django.apps import apps

def search_columns(query, model_name):
    model = apps.get_model(app_label='your_app_label', model_name=model_name)
    fields = model._meta.fields
    matching_columns = []

    for field in fields:
        try:
            value = getattr(model.objects.first(), field.name)
            if query in str(value):
                matching_columns.append(field.name)
        except:
            pass

    return matching_columns

from django.db.models import Q
from your_app.models import YourModel

def search_columns(query, field_names):
    q_objects = Q()

    for field_name in field_names:
        q_objects |= Q(**{field_name + '__contains': query})

    matching_rows = YourModel.objects.filter(q_objects)
    matching_columns = matching_rows[0]._meta.fields

    return [column.name for column in matching_columns]