All Questions
Tagged with fulltext-index or full-text-search
8,617 questions
2
votes
1
answer
79
views
How to combine diacritics-insensitive, case-insensitive and partial search in MongoDB?
I'm trying to implement a robust search function in my NestJS/Mongoose application that can handle partial matches while being case-insensitive and diacritics-insensitive (ignoring accents).
My ...
- 430
-1
votes
0
answers
101
views
How to enable full-text search feature in SQL Server on .NET Aspire?
How to enable full-text search feature in SQL Server for .NET Aspire?
var sqlServer = builder.AddSqlServer("sqlServer", builder.AddParameter("password123!!!", true))
.WithLifetime(...
- 3,542
0
votes
0
answers
45
views
Google Places SDK: How to prevent iOS text search from sorting results by distance?
I'm using the Google Places SDK for iOS and Android, along with the new Places API (New), to implement text-based place search (e.g., "pizza" near the current location).
I'm passing the same ...
3
votes
0
answers
78
views
The word "again" is not getting indexed when using MySQL InnoDB FullText index with ngram parser with token size 2
We noticed that full-text index searches were not returning results for the "again" search param.
We excluded the possibility that the word "again" is part of the MySQL FullText ...
0
votes
0
answers
73
views
MySQL Full-Text Search with ngram parser not prioritizing exact word matches
I have enabled a full-text index on my MySQL table with the ngram parser as shown below:
SHOW VARIABLES LIKE 'ngram_token_size'; -- Default set to 2
ALTER TABLE MyTable ADD FULLTEXT INDEX FT_MyTable (...
- 1,203
2
votes
1
answer
59
views
Why am I getting a return of false instead of true on the ts_query for this string
I'm learning about full-text search in postgres using ts_vector & ts_query, by analyzing texts in strings.
But I'm getting a false return but instead I should be getting a true output. Here is my ...
- 15
0
votes
1
answer
63
views
MySQL fulltext index search with multiple columns
MySQL fulltext index search with multiple columns
MySQL Table - sample_table:
col1
col2
col3
col4
Fulltext index:
Keyname: some_keyname
Columns: col1, col2, col3, col4
Question:
To search for a string ...
- 21
0
votes
1
answer
49
views
Entity with full-text search in Spring Boot
I have the following entity in a Spring Boot project:
@Entity
@Getter
@Setter
@Table(name = "listings",
indexes = {
@Index(name = "idx_exposition_east", ...
- 9,085
0
votes
0
answers
64
views
Optimizing MySQL LIKE Query with Pattern Matching for Large Data(20M+ records) and FULL TEXT SEARCH not giving accurate results
Optimizing MySQL LIKE Query with Pattern Matching for Large Dataset (20M+ records)
I'm struggling with performance issues in MySQL while searching through a large table containing over 20 million ...
- 11
0
votes
0
answers
30
views
OpenSearch: boolean with vector and full text
I am trying to combine a full text search and a vector search together in OpenSearch. When I run this:
{
"multi_match": {
"query": "generic search term"
}
...
- 2,748
0
votes
1
answer
44
views
Google Spanner: "SEARCH_NGRAMS cannot be used in transactional queries by default" error
I'm working with Google Spanner (MySQL) in a FastAPI application and encountering this error when trying to search for a column with search index on (as the docs):
status = StatusCode.INVALID_ARGUMENT ...
-4
votes
1
answer
57
views
Any workarounds for simulating multiple full-text indexes per collection in MongoDB?
Currently 2025, MongoDB community edition is about only 1 full-text index per collection.
The scenario is this:
Collection C already has full-text for 3 fields: FieldA, FieldB, FieldC
Need to search ...
- 8,769
0
votes
1
answer
88
views
FTS5 Virtual Table: Correct Syntax for Tokenizer Option to Treat Hyphen as Part of Tokens
I'm trying to create an FTS5 virtual table in SQLite such that hyphens (–) are treated as part of a token. My goal is to ensure that an address like "24-34" is indexed as a single token ...
- 101
0
votes
2
answers
67
views
Spring Boot Hibernate Search 6 Not Returning results for partial matches
I am implementing Hibernate Search 6 in my Spring Boot Application. I need the capability to search for partial matches, similar to %like% in SQL. From the documentation and other forums, it seems ...
- 321
1
vote
1
answer
62
views
How can I perform an 'AND' search across multiple full text index tables in my SQL Server command?
I'm currently using SQL Server 2016 and I need to search for n-number of user input terms across four different full-text index tables. We originally tried this:
DECLARE @searchString varchar(1000)
...
- 717
0
votes
0
answers
44
views
How to use AI or vector embedding approaches to find multi-word anagrams for arbitrary user input, against a SQL database of words?
I think I've figured out a reasonable solution to the anagram problem, in SQL, which I've answered here, and uses a DB system basically like this:
CREATE TABLE language_string (
id BIGINT NOT NULL ...
- 80.4k
0
votes
0
answers
78
views
Using Jetpack Compose, how do you develop a feature that highlights characters within a string that match text field input?
How do you develop a feature that changes the color of characters within a string that match the text entered into a text field, using Jetpack Compose?
This is a common feature in applications that ...
- 275
0
votes
1
answer
71
views
UNION ALL is extremely slow in postgres
I am new to postgres and am having trouble speeding this tsvector query up. I already have indexes on all the tables but the query is taking absurdly long. Any help is greatly appreciated as I assume ...
- 41
0
votes
2
answers
155
views
How to index a varchar column of unlimited length in Postgres?
I am using a Postgres table to store HTML data. One of the columns is of type varchar, and this is where the HTML data is stored. My understanding is that this column datatype has no maximum length.
I ...
- 18.6k
0
votes
0
answers
71
views
SELECT * FROM my_table where match('ZS'); not worked in manticore
I have install manticore successfully.and my manticore config file is:
source my_source{
type = mysql
sql_host = 127.0.0.1
sql_user = test
sql_pass = iflytek
...
- 1
-2
votes
2
answers
70
views
Why mysql fulltext-search so slowly?
The table xx_user_detail, user_id is int primary index, site1-site9 is combined fulltext index, the total row count is 5 million
SELECT * FROM xx_user_detail WHERE (user_id=14) AND MATCH (site1,site2,...
- 143
0
votes
0
answers
139
views
MySQL query to do FULL TEXT INDEXING and similar sound words
I have a table as shown below. A user can search this table on the basis of Interests. For example, user can search “Carl to”. Then it should return the first 2 emails, because we have 2 similar ...
- 792
0
votes
0
answers
82
views
Apache Lucene indexing strategy to handle large dataset on windows in desktop environment
I do have data divided into 60 sqlite database files. Each database represent a city. Number of rows is different in each database but schema is exactly same with total number of fields are 12. Out of ...
- 947
0
votes
0
answers
39
views
MySQL fulltext MATCH AGAINST IN BOOLEAN MODE query using a LEFT OUTER JOIN table's column unexpectedly returns no results [duplicate]
In MySQL 5.6.51 using InnoDB, I have two tables:
users
user_aka_names
Table details:
user_aka_names has a foreign key, user_id to users
One user can have many user_aka_names
Not all users have a ...
- 11
0
votes
1
answer
124
views
MySQL full-text search with aggregate functions
I have a website connected to a MySQL database of songs, and am working to improve full-text search on the site. A simple query with MATCH() works as expected, but as soon as I add an aggregate ...
- 296