I need to create suggestion autocomplete for all the columns of a table in a single searchbox using postgres database. I have a search autocomplete in web page and need to autosuggest the options. ...

How to insert a text file into a field in PostgreSQL? I'd like to insert a row with fields from a local or remote text file. I'd expect a function like gettext() or geturl() in order to do the f...

I would like to do full-text searching of data in my Ruby on Rails application. What options exist?

I've been looking into searching plugins/gems for Rails. Most of the articles compare Ferret (Lucene) to Ultrasphinx or possibly Thinking Sphinx, but none that talk about SearchLogic. Does anyone h...

When running the following query: select ts_headline( $$Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean vitae mauris ac metus pellentesque malesuada. In hac habitasse platea dictu...

I'm (re)confused about tsvector fields. It's very common to see examples of text being concatenated into a tsvector field, and then indexed. If you look up PG 12 generated columns, you'll find exam...

I want to use full text search in my project... Can anyone explain me, what is the difference between ElasticSearch and SQL Full Text Search Or why SQL Full Text Search is better (worse) th...

I followed the docs and it's almost work well but when I use Full-text Search i got an error: Unsupported lookup 'search' for CharField or join on the field not permitted How can I fix it?

i'm looking for an existing module(s) which enabled me to write basic boolean queries for matching and searching texts, WITHOUT writing my own parser etc. for example, president AND (ronald...

Running a MYSQL query with REGEX and I get a timeout error. I have a Bitnami NGINX Wordpress stack on AWS with Ubuntu 16. Using MYSQL 8.0.16 What settings in MYSQL (or whereever else) do I need to ...

I have a following MySQL query: SELECT p.*, MATCH (p.description) AGAINST ('random text that you can use in sample web pages or typography samples') AS score FROM posts p WHERE p.post_id <&gt...

The following query results in an error due to the @ (at symbol). The query will work fine when it is removed. I tried escaping the @ character, but no luck. SELECT * FROM clients WHERE MATCH (for...

Using MySQL 5.6, this request SELECT foo FROM bar WHERE groupId = '1' AND MATCH (foo) AGAINST ('"myQuery"' IN BOOLEAN MODE); and SELECT foo FROM bar WHERE groupId = '1' AND foo like '%myQuer...

I have pretty complex JSONB stored in one jsonb column. DB table looks like: CREATE TABLE sites ( id text NOT NULL, doc jsonb, PRIMARY KEY (id) ) Data we are storing in doc column is a com...

public class Product { private Long id; private String name; private String description; } Is there any way to implement a full text search with JpaRepository for the description of the c...

there are 5 fields in each document if simply hit the api. but i want only these two fields(user_id and loc_code) so I mentioned in fields list. but still it return some unnecessary data like _shar...

I am trying to understand how you update an indexed document in Elasticsearch. I don't understand how it works? What is the ctx that the API is referring to doing? Let say you have a document with ...

I'm looking for something like EF.Functions.FreeText that was implemented in SQL Server but using the MATCH...AGAINST syntax of MySQL. This is my current workflow: AspNetCore 2.1.1 EntityFramework...

I need to make search-as-you-type autocomplete for a large list of companies (over 80,000,000). The company name should contain the word that starts with a search query like this +-------+--------...

My fulltext index option in sqlserver2008 is greyed out? Is it a seperate install?

My question is about using full text search. As I know like queries which begin with % never use index : SELECT * from customer where name like %username% If I use fulltext for this query can I ta...

I have keywords like "some-or-other" where the hyphens matter in the search through my mysql database. I'm currently using the fulltext function. Is there a way to escape the hyphen chara...

I have a table of images with sentence captions. Given a new sentence I want to find the images that best match it based on how close the new sentence is to the stored old sentences. I know that I...

I've recently seen a lot of libraries for searching and highlighting terms within an HTML page. However, every library I saw has the same problem, they can't find text partly encased in an html tag...

Running the following text search directly on MongoDB results in no issues: db.getCollection('schools').find({ $text: { $search: 'some query string', $caseSensitive: false, $diacriticSensitiv...