8,616 questions
2
votes
1
answer
85
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
2
votes
1
answer
87
views
Way to simply list the Forms of a word by the full-text parser?
We're using fulltext indexes in current builds of SQL Server and/or Azure SQL - compatibility levels well over SQL Server 2016 or higher, preferably SQL Server 2022 on Azure.
While the searching in a ...
- 976
0
votes
1
answer
88
views
MongoDB Atlas Search Index Too Slow
I need to search crypto tokens by name (text search), symbol (exact match) or address (prefix match, i.e. return all tokens the address of which starts with the user query). Instead of relying on a ...
- 620
0
votes
0
answers
46
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 ...
0
votes
0
answers
49
views
Why does LanceDB's full-text-search fail to find matches where the exact text is present?
I am trying to use lancedb to perform FTS, but getting spurious results.
Here is a minimal example:
# Data generation
import lancedb
import polars as pl
from string import ascii_lowercase
words = [...
- 41
3
votes
0
answers
81
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
41
views
Oracle 19c Text Option: Behaviour of CONTAINS with NEAR and MAX_SPAN
We found a strange behaviour of Oracle full text search when using contains(text, 'NEAR((A,B,C,D), 2, true)') where 2 is the max_span parameter. The documentation says:
max_span Optionally specify ...
- 1,804
0
votes
0
answers
78
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
0
votes
0
answers
112
views
Why doesn't VS Code pop up context menu on top level folder / project folder provide Search option?
When I right-click on the top most / top level / project folder / root folder to get the context pop-up menu, I don't get a Search option in that menu:
In my case, in the picture, the top most folder ...
- 6,848
2
votes
1
answer
66
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
0
answers
171
views
Correct design for SQL table in SQLite3: how to optimize substring search?
I am using SQLite3 in C++ where I need to store text data. There are 7 columns in the table. I need to filter data by 7 columns. I need to check for equality of 6 columns to a specific value, and I ...
- 1,349
0
votes
1
answer
66
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
0
answers
40
views
Chinese chapter lookup shows too many nodes because of variant characters – how can I keep it fully local and still match precisely?
I'm building an offline-only CLI tool that searches our company rulebook, stored as hierarchical JSON:
Levels like 3, 3.2, 3.2.1 …
router(query) chooses the node by comparing the query with each ...
0
votes
1
answer
52
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
1
answer
41
views
SQLite FTS, how to return only matching line in SQL?
I have a virtual full text search table in SQLite. I can query it like this.
select body from my_table where body match 'foo';
This works great to return an entire row that matches 'foo'.
However, my ...
- 7,699
0
votes
0
answers
68
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
1
answer
115
views
Azure Search query for partial match
I'm using Azure Search and have an index including this field
{
"name": "Segment1",
"type": "Edm.String",
"searchable": ...
0
votes
0
answers
34
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
0
answers
44
views
If a cell contains 3 different texts then today's date
I am trying to add today's date on a column if that column contains 3 different words. I can do it with 1 word but no with 3 different.
More specific: If B11 contains "Accepted, rejected or ...
- 1
0
votes
1
answer
51
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 ...
3
votes
2
answers
76
views
Postgresql delay in queries using wildcard '%searchTerm%' in large set database
Currently, I have the follow real use case challenge.
Library admins want to search for books in their library database using book and category names. Their database has over 2 million book records, ...
- 151
-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
1
vote
1
answer
85
views
MongoDB: Creating an Index for Efficient Regex Search on a Text Field
I have a MongoDB collection where I store values as concatenated object references in a single string field. The values are structured like this:
{
"resource": {
"fields": {
...
- 43
0
votes
1
answer
92
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
1
answer
61
views
Why Redis JSON index creation/querying with non-English languages doesn't work? [closed]
I create the index:
const searchSchema: any = {
"$.Id": { type: SchemaFieldTypes.TEXT, AS: "Id", NOSTEM: true },
"$.FirstName": {
type: SchemaFieldTypes.TEXT,
...
0
votes
2
answers
74
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
0
votes
0
answers
125
views
How to Create a Partial Atlas Search Index in MongoDB Based on a Filter?
I am using MongoDB Atlas Search and want to create a partial search index where:
Only specific documents are indexed based on a field condition (e.g., status: "active").
Only specific fields ...
- 61
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
1
answer
103
views
Cursor pagination for query based full-text search
I need to implement cursor based pagination on an endpoint which accepts a search query. The problem is that since rows will be ranked based on a relevance score derived from a full-text search in ...
- 410
0
votes
0
answers
47
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.5k
0
votes
0
answers
48
views
How can I get multiple results per document from full-text search?
My SQLite database for full-text search contains book contents. Each book is stored as a single document in the FTS table. At most one result is returned per book even though there are multiple ...
- 77
0
votes
0
answers
84
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
46
views
MariaDB FTS skips stopwords in Boolean mode
I am using MariaDB 10.6.19 with a full text search in boolean mode.
If I understood the knowledge base correctly, stopwords should not be ignored here and should be found as well.
Simple example I ...
- 31
0
votes
1
answer
76
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
1
vote
2
answers
79
views
In SQL, how to search for rows by binary data prefix?
For example, I want to search for all rows that starts with \x00\xff\xaa in a binary data column. I am writing this pseudo-code in C# Entity Framework:
IEnumerable<KeyValue> ...
- 412
0
votes
2
answers
157
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.7k
0
votes
0
answers
42
views
Issue with Indexing Nested Documents in Solr 8.11
I am currently facing an issue with indexing nested documents in Solr 8.11. According to the documentation, the IDs of child documents should be automatically generated by concatenating the ID of the ...
- 28
0
votes
0
answers
73
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
1
vote
0
answers
15
views
How to use TextIndexed with subDocument (MongoDB & Java)
I have a document with name User and this document has subDocument with name UserIdentifier like below:
@Data
@Document
public class User {
private List<UserIdentifier> userIdentifierList;
...
-2
votes
2
answers
78
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
1
answer
51
views
How to handle alphanumeric combinations (like "Hotel101") in Elasticsearch query results with multi_match?
I am working with Elasticsearch and I have an index that contains entries with alphanumeric combinations like "Hotel101 fort". When I search using a query like "Hotel 101 fort", I ...
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
1
answer
1k
views
Qdrant: create index on payload text field
I am using Qdrant to store vectors and payload. For example, my documents are like:
{ "id": 1234,
"title": "my_title",
"description": "my_description&...
- 732
0
votes
0
answers
87
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
2
votes
0
answers
163
views
The value of citation entity field 'citation.appearance.abstract' exceeds the length limit. The maximum length is '480' characters
I have a problem integrating Azure OpenAI with Microsoft Teams through the Teams toolkit. The response generated by the API exceeds the character limit allowed in Teams, which causes constant errors ...
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
0
answers
46
views
FULLTEXT searching for spaces, full stops
I am experimenting with FULLTEXT searching, using the InnoDB storage engine. I am upgrading from MYISAM to InnoDB and I have noticed that a lot of queries containing LIKE clauses, which were fast ...
- 846
0
votes
1
answer
126
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
0
votes
1
answer
157
views
MariaDB fulltext index tokenization rules / DOC_ID mapping
First question: is there a document that describes the rules how MariaDB builds the fulltext index words (for InnoDB)?
I set innodb_ft_min_token_size=1 to include also one letter words in the index. ...
- 460
0
votes
0
answers
44
views
Would a fulltext index across multiple columns be better in this case?
Currently, the search query that I'm using for searching my forum looks like this (this particular search was for the term "6.18") (this is just part of the where clause that deals with ...
- 5,123