以下查询将执行以下操作:
>>> sentence = 'A brown cat jumps over a person'>>> MyModel.objects.extra(where={"%s like CONCAt('%%', `name` ,'%%')"}, ... params=[sentence]).values()[{'id': 1L, 'name': u'brown cat'}, {'id': 3L, 'name': u'person'}]
以下查询将执行以下操作:
>>> sentence = 'A brown cat jumps over a person'>>> MyModel.objects.extra(where={"%s like CONCAt('%%', `name` ,'%%')"}, ... params=[sentence]).values()[{'id': 1L, 'name': u'brown cat'}, {'id': 3L, 'name': u'person'}]