FTS3/FTS4 doesn't work in python by default (up to 2.7). I get the error: sqlite3.OperationalError: no such module: fts3 or sqlite3.OperationalError: no such module: fts4 How can this be resolved...

I am trying to figure out how to use TrigramSimilarity with unaccent for multiple fields. So far i have: def filter_by_location(self, queryset, location): log.info('Filtering location: "{locatio...

Does Microsoft Access have Full Text Search? I know that MySQL and SQL Server have Full Text Search, but I am not too certain on Access. If Access doesn't have Full Text, what is the best alterna...

I am searching a python script for a string, but I would like to see not just the lines that contain the string, but also if that code is nested inside a function or method (or, optionally, a loop ...

Since it is not possible to find "blueberry" by the word "blue" by using a mongodb full text search, I want to help my users to complete the word "blue" to "blueberry". To do so, is it possible to ...

Let's say I have a fairly simple app that lets users store information on DVDs they own (title, actors, year, description, etc.) and I want to allow users to search their collection by any of these...

I've recently upgraded to Spring Data MongoDB 1.6.0.RC1, which is very good and implements the full text search feature of MongoDB 2.6 (huuurah!). My question is: how can I combine the Criteria and...

Novice on Lucene here. I'm using it with Hibernate in a java client, and have been getting this error on a particular query: HSEARCH000146: The query string 'a' applied on field 'name' has no mea...

I am creating search for photo gallery project where photos could have upto 50 tags (just like in shutterstock and fotolia). I am creating my search in elasticsearch. I have a field with datatype k...

I am looking for SQL Server 2016 full text indexes and they are awesome to make searches for finding multiple words containing strings When i try to compose the full text index, it shows Statistic...

How to full text search and have filter? I want to search for a text among documents with language_id=10. I've tried it this way: { "query": { "query_string": { "query": "Declared" }, { "fil...

I have three tables in my database which are: messages topics comments Each of these tables has two fields called 'content' and 'title'. I want to be able to use 'Like' in my sql statement to lo...

MySQL provides FULLTEXT indexes, that can be retrieved with the MATCH (col1,col2,...) AGAINST (expr [search_modifier]) construct. There are several Full-Text Search variants, one of them (and the d...

I want to remove the stop words from my data but I do not want to stem the words since the exact words matters to me. I used this query. SELECT to_tsvector('english',colName)from tblName order b...

When I change the order of the keywords in a boolean search, I get the same result but very different performance results. The profiling on MySQL 5.6.33 with a MyISAM table, ft_min_word_len=2 and ...

I'm pretty new to MySQL full-text searches and I ran into this problem today: My company table has a record with "e-magazine AG" in the name column. I have a full-text index on the name column. W...

Is there a way to limit the amount of text in a text field from a query? Here's a quick scenario.... I have 2 fields: docId - int text - string. I will query the docId field and want to get a...

I working on a Solr 4 for optimizing my solr results rank based on popularity rank stored in Index. Now when someone searches, apart from relevancy rank, I want to influence relevancy rank using p...

Is there any way to boost search results on same field depending on type? My basic boosting is something like: GET _search { "query": { "simple_query_string": { "query": "mangan", "fields":["...

How do you espace special characters in string passed to to_tsquery? For instance, this kind of query: select to_tsquery('AT&T'); Produces: NOTICE: text-search query contains only stop word...

If anyone has experience using Oracle text (CTXSYS.CONTEXT), I'm wondering how to handle user input when the user wants to search for names that may contain an apostrophe. Escaping the ' seems to ...

I want to write a web application using Google App Engine (so the reference language would be Python). My application needs a simple search engine, so the users would be able to find data spe...

I need to search across multiple columns from two tables in my database using Full-Text Search. The two tables in question have the relevant columns full-text indexed. The reason I'm opting for Fu...

I realize that a lot of questions have been asked relating to full text search and Entity Framework, but I hope this question is a bit different. I am using Entity Framework, Code First and need t...

I'm looking for a way to emulate something like SELECT * FROM table WHERE attr LIKE '%text%' using a tsvector in PostgreSQL. I've created a tsvector attribute without using a dictionary. Now, a qu...