title: Django MySQL full text search
body: <p>I need to implement full text search for my Django application, running MySQL as backend.</p>
  
  <p>Let's say I've got a model as follows:</p>
  
  <pre><code>class MyItem(models.Model):
      title = models.CharField()
      short_description = models.TextField()
      description = models.TextField()
  </code></pre>
  
  <p>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.</p>