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,site3,site4,site5,site6,site7,site8,site9) AGAINST ('苏娟的食品店'); this SQL1 use 0.3s SELECT * FROM xx_user_detail WHERE…
We have an Express API that connects to a Postgres database using Sequelize. One of our endpoints returns a list of sales, which accepts different query parameters like page, column order, filters, and a search term. And that search is…
I have a PostgreSQL table named users which contains between 20 to 30 million records. The table has the following columns: id, tenant_id, name, company, location, and description. I need to perform generic search queries on this table with various…
I am trying to construct a full text search where half words should be matched. In my example, the column value is 'offer' and the search term is 'off'. I construct the query like this. The first line does NOT…
I'm encountering an issue with whereFullText in Laravel. Here's my code: $search_key = $args['q'] ?? $args['search_key'] ?? NULL; $builder->when($search_key, function (Builder $builder, $search_key) { $builder->whereFullText(self::fullTextColumns(), $search_key . self::WILDCARD, [ 'mode' => 'boolean', // [ natural, natural language, query expansion, boolean…
I want to make a full search query on a spécific value of my jsonb like the format of the json is : { "highlights": { "concise": null, "complete": null }, "gist": { "concise": [ { "text": "", "isHighlighted": false,…
I'm seeking help regarding full-text searching in MySQL. I have two tables, Article and Keywords. Article: id int, description (varchar(600)) Keyword: id int, value (varchar(50)), article_id int An article can have multiple keywords. For example: id:1, keyword1, article_id: 1 id:2,…
I have a list containing terms that vary in length from 1 to 10 words, with approximately 500,000 entries. My goal is to search for these terms in a long text (converted from a PDF, typically 1.5 to 2 pages…
I have a php-script to search in my webspace-files. I can toggle (case) if I want to search case-sensitive. It function if I toggle case-sensitive. But when deselect this option I get no result if my word is in upper-case.…
I am using Azure cognitive search for a RAG based solution. On giving the search keywords like " vendors with apple, oranges and lemons". It is returning vendors who supply either of the three and not the vendors who supplies…