Django MySQL full text search

by

The previously highest rated answer is deprecated. As of Django 1.10 there is no more search field lookup for MySQL databases (see the search section in the 1.10 documentation).

The release notes for 1.10 also propose a solution to this, by defining a custom lookup:

###__search query lookup

The search lookup, which supports MySQL only and is extremely limited in
features, is deprecated. Replace it with a custom lookup:

from django.db import models

class Search(models.Lookup):
   lookup_name="search"

   def as_mysql(self, compiler, connection):
       lhs, lhs_params = self.process_lhs(compiler, connection)
       rhs, rhs_params = self.process_rhs(compiler, connection)
       params = lhs_params + rhs_params
       return 'MATCH (%s) AGAINST (%s IN BOOLEAN MODE)' % (lhs, rhs), params

models.CharField.register_lookup(Search)
models.TextField.register_lookup(Search)

More Related Contents:

  1. How can I temporarily disable a foreign key constraint in MySQL?
  2. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  3. Search for “whole word match” in MySQL
  4. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  5. MySQL match() against() – order by relevance and column?
  6. mysql fulltext search failure
  7. Problems with contenttypes when loading a fixture in Django
  8. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  9. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  10. GROUP_CONCAT equivalent in Django
  11. What’s the best way to migrate a Django DB from SQLite to MySQL?
  12. How to use django models with foreign keys in different DBs?
  13. How to drop all tables from the database with manage.py CLI in Django?
  14. Database returned an invalid value in QuerySet.dates()
  15. Error installing mysqlclient for python on Ubuntu 18.04
  16. MySQL Fulltext Search Score Explained
  17. django cannot connect mysql in docker-compose
  18. How to allow fulltext searching with hyphens in the search query
  19. How can I tell when a MySQL table was last updated?
  20. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  21. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  22. mySQL longitude and latitude query for other rows within x mile radius
  23. Get results that fall within marker radiuses from database
  24. Bash script to insert values in MySQL
  25. Laravel join with 3 Tables
  26. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  27. How do I split the output from mysqldump into smaller files?
  28. How to remove duplicate entries from a mysql db?
  29. PDO and MySQL Fulltext searches
  30. How to escape apostrophe (a single quote) in MySql?

Leave a Comment