Questions tagged [full-text-search]
Full text search involves searching documents, usually involving unstructured text, as opposed to searching text fields in a structured database.
full-text-search
8,005
questions
0
votes
0
answers
23
views
What to use for text search for a niche e-commerce site using Postgres
I have this small/medium e-commerce site for a niche market. We have tens of thousands of products and are looking to implement of fully functional search bar (previously searched through guided flow/...
0
votes
1
answer
30
views
Is there a way to limit the long list of search results in my live javascript search bar so it responds faster on desktop browsers?
I have a javascript live search bar, it reads a .js file that holds the records. I added about 20,000 records to the original and an equal amount of corresponding links for those records. On my mobile ...
0
votes
0
answers
44
views
Full text search, not finding subitems
I have setup Microsoft SQL Server full text search on a few tables.
These tables contain numbers, like phone numbers.
If I do a contains search on the full number, it returns matches, but not on a ...
0
votes
0
answers
23
views
Is there an option on Typesense to allow unlimited documents?
I recently moved from meilisearch to typesense on my Laravel app working with scout.
I've done all my configuration of models and search queries.
I was using a local instance of typesense which ...
0
votes
0
answers
33
views
web aplication using php pdo fulltext search delivers result on ubuntu system but not on windows system; identical DB on both
The setting
Windows 11
Server-Version: 8.4.0 - MySQL Community Server - GPL
Apache/2.4.61 (Win64) PHP/8.3.8
Ubuntu
Server-Version: 10.3.39-MariaDB-0ubuntu0.20.04.2 - Ubuntu 20.04
Apache/2.4.41 (Ubuntu)...
1
vote
1
answer
36
views
Multicolumn seach vector with postgresql
In a postsgresql v13 database, I want to add a search vector on a table, and i want to put several columns (not all the same type) in that vector.
I have some 7 text columns, 1 json column and 1 jsonb ...
0
votes
0
answers
25
views
MongoDB aggregation pipeline: pagination is not working as expected with id cursor and text index
I'm making an aggregation query to my MongoDB using a text index, I implemented a pagination system but it's not working as expected
At first, I thought it was related to the other sort field, but it ...
0
votes
2
answers
78
views
Parse a search string into words and treat words within double quotes as a single term
I know that if I want to parse a string into separate words, the easiest way is.
This is my string:
The Microsoft business analysis software
Code:
SELECT special_term, display_term
FROM sys....
-1
votes
1
answer
34
views
SQLite slow combined query from two fast SELECT queries
Select join query with FTS table is slow if other WHERE conditions are specified. But these WHERE conditions without fts MATCH condition are not slow and fts MATCH is not slow alone. How to combine ...
0
votes
0
answers
11
views
How to create an Instant indexing plugin function for a core PHP website currently used in the WordPress platform?
WordPress platform is easy to use because of themes & plugins. Now, the Instant indexing plugin is very useful to submit newly added pages to Google Search indexing API.
Similar actions want to ...
0
votes
1
answer
42
views
Elasticsearch Query for Exact Substring Matching with Spaces
I'm trying to perform an exact substring match in Elasticsearch, including substrings that contain spaces. Here’s what I need:
Search for an exact substring within a larger text field.
The substring ...
0
votes
0
answers
21
views
How does standard text search work across languages, with respect to problems like vowels in Hebrew?
In Hebrew, the vowels (nikkud) are optional and, when included, are written around the main text. For example, the name Miriam is מרים without vowels or מִרְיָם with vowels (note the little dots and ...
0
votes
0
answers
28
views
can't delete FullTextIndex from table
I recently migrated a SQL Server 2005 to SQL Server 2012, then to SQL Server 2019. Now the database integrity check throws errors about the full text index files on two tables.
When I check the SQL ...
0
votes
1
answer
28
views
Next.js Prisma FindMany Query Fails for Certain Search Strings in PostgreSQL
My Question: How can I modify my query to include terms like "United States" without causing errors?
I am using Prisma with PostgreSQL and facing an issue with the findMany method. Here's ...
0
votes
2
answers
38
views
c# find word and parts of that word seperated by spaces
I have a lot of texts and a search term, for example 'simcard'. I then want all places where 'simcard' appears, but also 'sim card', for example.
How should I achieve that?
You can of course delete ...