title: How can I make Django search in multiple fields using QuerySets and MySql "Full Text Search"?
body: <p>I'm a <strong>Django</strong> novice, trying to create a "<strong>Search</strong>" form for my project using MySql with MyISAM engine. So far, I manage to get the form to work, but Django doesn't seem to search all fields the same way. Results are random. Exemple: search in <code>region</code> returns no result or worst search in <code>description</code> works fine while <code>howtogetin</code> doesn't seem to apply..   </p>
  
  <p>Here is my model:</p>
  
  <pre><code>class Camp(models.Model):
      owner = models.OneToOneField(User)
      name = models.CharField(max_length=100)
      description = models.TextField()
      address1 = models.CharField(max_length=128)
      address2 = models.CharField(max_length=128)
      zipcode = models.CharField(max_length=128)
      region = models.CharField(max_length=128)
      country = models.CharField(max_length=128)
      phone = models.CharField(max_length=60)
      howtogetin = models.TextField()
  
      def __str__(self):
          return self.name
  </code></pre>
  
  <p>Here is my view:</p>
  
  <pre><code>def campsearch(request):
  if request.method == 'POST':
      form = CampSearchForm(request.POST)
      if form.is_valid():
          terms = form.cleaned_data['search']
          camps = Camp.objects.filter(
              Q(name__search=terms)|
              Q(description__search=terms)|
              Q(address1__search=terms)|
              Q(address2__search=terms)|
              Q(zipcode__search=terms)|
              Q(region__search=terms)|
              Q(country__search=terms)|
              Q(howtogetin__search=terms)
              )
          return render(request, 'campsearch.html', {'form':form, 'camps':camps})
  else:
      form = CampSearchForm()
      return render(request, 'campsearch.html', {'form':form})
  </code></pre>
  
  <p>Any clue?</p>