Meanwhile I have managed to solve the issue. The problem was that I had my own stop list which was indeed empty but my fulltext catalog was associated not with my own stoplist but with the system one. Here are a couple of useful queries for solving stopword and full text search issues: Query stopwords … Read more
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 … Read more
Assuming you are using MyISAM engine, Execute: ALTER TABLE products ADD FULLTEXT(brand); The fulltext index should contain exactly the same number of columns, in same order as mentioned in MATCH clause.
I don’t think I could explain it better than the manual already does: In choosing which index type to use, GiST or GIN, consider these performance differences: GIN index lookups are about three times faster than GiST GIN indexes take about three times longer to build than GiST GIN indexes are moderately slower to update … Read more
Websolr provides a cloud-based Solr with a control panel. It’s in private beta as of this writing, but you can get the service through Heroku. Another hosted Solr service is PowCloud, also in private beta, which seems to offer strong WordPress integration. SolrHQ: another beta service providing a hosted Solr solution, with Joomla and WordPress … Read more
None of the existing “NoSQL” database provides a reasonable implementation of something that could be named “fulltext search”. MongoDB in particular has barely nothing so far (matching using regular expressions is not fulltext search and searching using $in or $all operators on a keyword word list is just a very poor implementation of a “fulltext … Read more
Make sure you have full-text search feature installed. Create full-text search catalog (if needed) First check if any catalog already exists select * from sys.fulltext_catalogs If no catalog is found create one use [DatabaseName] create fulltext catalog FullTextCatalog as default you can verify that the catalog was created in the same way as above Create … Read more
Create three full text indexes a) one on the keyword column b) one on the content column c) one on both keyword and content column Then, your query: SELECT id, keyword, content, MATCH (keyword) AGAINST (‘watermelon’) AS rel1, MATCH (content) AGAINST (‘watermelon’) AS rel2 FROM table WHERE MATCH (keyword,content) AGAINST (‘watermelon’) ORDER BY (rel1*1.5)+(rel2) DESC … Read more
Most Basic Answer I’m using the plain sql below so that everything is as clear and readable as possible. In your project you can use the Android convenience methods. The db object used below is an instance of SQLiteDatabase. Create FTS Table db.execSQL(“CREATE VIRTUAL TABLE fts_table USING fts3 ( col_1, col_2, text_column )”); This could … Read more
A multivalued field is useful when there are more than one value present for the field. An easy example would be tags, there can be multiple tags that need to be indexed. so if we have tags field as multivalued then solr response will return a list instead of a string value. One point to … Read more