Django MySQL full text search

Question

I need to implement full text search for my Django application, running MySQL as backend.

Let's say I've got a model as follows:

class MyItem(models.Model):
    title = models.CharField()
    short_description = models.TextField()
    description = models.TextField()

I would like to have results first for search term occurences in title, then in short_description and at the end in description field. I'll be happier if I don't have to use additional modules/applications for this task. Any idea?

Thanks in advance.

Answer 1

Here is a nice tutorial without extra applications: http://www.mercurytide.co.uk/news/article/django-full-text-search/

Answer 2

If you are looking for a beefy solution I recommend http://haystacksearch.org/

It is very well thought out.

Answer 3

You can use full text search in django

MyItem.objects.filter(title__search="some search text")

One thing is - you can't define a fulltext index from a Django model, you need to do in directly in a database (using PHPMyAdmin or SQL query)

See Django documentation: http://docs.djangoproject.com/en/dev/ref/models/querysets/#search