Category "full-text-search"

PHP - Check if string contains words longer than 4 characters, then include "+ *", and for those shorter than 4 characters include only "*"

I manage to do partially just one part, but cannot make the second part work. If a word has < 4 characters, only * should be included at the end of that wo

AWS Neptune FTS returns IOException on every federated queries to OpenSearch

I am trying to implement full text search on AWS Neptune (engine 1.0.4.2) with AWS OpenSearch. A GET amazon_neptune/_search on OpenSearch returns: { "took": 5

Setting ft_stopword_file back to default (built-in) without restarting MySQL

I need to test something by changing the ft_stopword_file without restarting the server. I know that SET GLOBAL works to change global variables until the next

Mongodb: Text Indexes vs Atlas Search

These two features look pretty simmilar, but Atlas Search is fresh and maybe more powerfull. Is Atlas Search a replacement for Text Indexes in MongoDb? Will Tex

Fulltext index match string with period (.) mysql

I have a few column fulltext indexed and i'm testing some string to search. My db contains cars components so my researches could be for example "Engine 1.6". T

Designing tags system with nosql/elastic search

I have to design a system with this schema. { "documentId" : 123 "documentType" : "paper" "tags" :["abc","xyz"] //other meta data of document } The queries

Can't join FREETEXTTABLE with typeORM functions

I'm working on a graphQL backend with TypeORM I found FREETEXT, CONTAiNS, FREETEXTTABLE and CONTAINSTABLE options for fulltext searching in my SQL database. As

SQL Server \ CONTAINS FORMSOF INFLECTIONAL Phrase \ Not Working as Expected

I am trying to use the contains operator with FORMOF INFLECTIONAL, but I'm not getting what I think is the expected result. Here is the query. This query is no

Most matching words in search query

I have user table (e.g. UserMst) is MySQL like UserID FirstName LastName FullName (expression column) ------ --------- -------- -----------------------

Most matching words in search query

I have user table (e.g. UserMst) is MySQL like UserID FirstName LastName FullName (expression column) ------ --------- -------- -----------------------

How do you full text search in an amazon s3 bucket?

What are options to create solution based on the AWS native platform to be able to full text search in an amazon s3 bucket/s. We have process that will be stori

If a cell in range of cells in Excel 2010 contains specific text, move whole cell text into a different column

I am struggling to find an answer to this one... Each month I am provided with a spreadsheet full of clients data that is a raw extract from some sort of CRM s

In VS Code file searching, can I expand (or collapse) all results?

In the Search pane of the program, after I hit Enter, all files are listed, with some expanded to show results in a file, and others collapsed. I'm wondering fi

Conditions (like "like") on binary field (blob) in oracle

How can I search in (put condition on) blob field in oracle, like text fields? I need someting like: select * from table_name where blob_field like '%00ff00ff