How to match string with database fields in Django?

Question

I have one database with column - where is datas like

'Very big News'
'News'
'something else'
'New Nes'
'Fresh News'
'Something else'

I need match with my database.I Need go through every row in this database and find if i have string field which is inside of this string field.

for example if i have field 'News' which is inside.

I need implement it in django.

How to mutch if i have field with name 'News' in my database?

I mean if i have value in my row which is contained in this particular string?

I can drop this string by list of words and than check every word. But it is not the best way. Isn't it?

Again:

I have string 'super very news' I need look in my database if i have name field which contain word 'super' or 'very' or 'new' or 'super very' or 'very news'.

Answer 1

Update based on comments. See the query set docs here.

your_search_query = 'super very news'

qset = Q()
for term in your_search_query.split():
    qset |= Q(name__contains=term)

matching_results = YourModel.objects.filter(qset)

This creates the equivalent of:

matching_result = YourModel.objects.filter(Q(name__contains='super') |
                                           Q(name__contains='very') |   
                                           Q(name__contains='news'))

which produces (roughly) the following SQL in a single query:

 select * from your_model where name like '%super%' or name like '%very%' or name like '%news%'

Answer 2

If your word list is small and simple you can write your own lookup table and indexer, otherwise you want a full text database like OpenFTS:

http://openfts.sourceforge.net/