Questions tagged [full-text-search]

0

votes
0

answer
3

Views

Is there an option in Powerapps to split a search text into individual strings and to display on a gallery only items that include “all” strings?

my case is similar to this case: Click here! I have a gallery which displays items from a Collection. I already added a Textinput.Text to give customers the opportunity to search for items. But, what I am struggling with is to implement a 'full-text' search. The solution @carlosfigueira offered in...
Sascha Dornig
1

votes
1

answer
664

Views

PostgreSQL: get value of object inside jsonb array for full text search

How do I get a certain value based on a key inside an object that is part of my array? I store my json data as jsonb inside my Postgres 9.6 DB addresses (JSONB) --------- [{'address':'[email protected]', 'type': 'home'}, {'address':'[email protected]', 'type': 'work'}] What I'd love to do is something like: SEL...
1

votes
4

answer
1.3k

Views

Any idea why contains(…) querys so slow in SQL Server 2005

I've got a simple select query which executes in under 1 second normally, but when I add in a contains(column, 'text') into the where clause, suddenly it's running for 20 seconds up to a minute. The table it's selecting from has around 208k rows. Any ideas what would cause this query to run so slow...
Robin
1

votes
2

answer
1.1k

Views

Mongo db full text search and priorities

I'm planning to build a full text search in my php application powered with Mongo db. The full text search will be hover collection's documents stored like this: title: 'the title' STRING description: 'the description' STRING So, as the Mongo Db official guide says, i must split the field where i mu...
itsme
1

votes
0

answer
7

Views

What is the syntax for MariaDB 'IN NATURAL LANGUAGE MODE'?

According to the MariaDB documentation: There are no special operators, and searches consist of one or more comma-separated keywords. The search clearly does not need to be comma-separated, as replacing commas with spaces gives the same result. I assume that it breaks the string into separate keywor...
Liam
0

votes
0

answer
2

Views

Fuzzy Search with Matching Term Sequence in ElasticSearch

I am beginner to the ElasticSearch. I am trying to create search where it will handle minor spelling mistakes and show result. For this purpose I have used Fuzziness in match query as below. { 'query': { 'match': { 'CompanyName': { 'query': 'CBL Da', 'fuzziness': 'AUTO', 'prefix_length':3, 'max_expa...
Krunal Zala
1

votes
1

answer
38

Views

MySQL FullText search returns 0 if multiple row matches

Match / Against returns true if I pass unique value in query and returns 0 if I pass value, which exist in multiple row. SELECT MATCH(b.branch_name) AGAINST ('Men' IN NATURAL LANGUAGE MODE ), branch_name FROM `branch` AS `b` WHERE 1 Table Data: id | branch_name -------------------- 1 | Men 2...
minc
1

votes
1

answer
281

Views

Algolia rails sortBy dynamically

I'm building a search using Algolia rails but having difficulties when doing sort by dynamically. For example, user can choose from a dropdown to sort by price asc or price desc. Here is my model where I defined the indices class Product < ActiveRecord::Base include AlgoliaSearch algoliasearch per_e...
Louis
1

votes
1

answer
934

Views

How to search word or string on all fields in document with MongoDB?

We have a situation where a user would like to have a single 'omni-box' for searching for a word\phrase anywhere in a document. Is MongoDB able to perform this search or would it have to be an explicit search of every field?
BanksySan
1

votes
1

answer
207

Views

Text search - mongodb

I am using mongo text search in my application. Index: db.test.createIndex( { title: 'text', description: 'text' }, { name: 'TextIndex', weights: { title: 10, description: 1 } } ) Score: title : 10 description : 1 Document: db.test.insert( [ { _id: 1, title: 'agent de production', description: 'pro...
karthick
1

votes
1

answer
1.1k

Views

use of $text with mongoose for text search is not working

I am trying do text search using $text as shown below var express = require('express'); var app = express(); var mongoose = require('mongoose'); var bodyparser = require('body-parser'); var port = process.env.PORT || 8000; var router = express.Router(); var cors = require('cors'); var Schema = mon...
DhanaLaxshmi
1

votes
1

answer
257

Views

Custom search in SQL with rank by columns

I would like to implement intelligent search form for my users stored in SQL Server. Columns which I want to use for search are show on screenshot below. But some columns have higher priority. For example if email or phone match with item in DB it will have higher rank then for example founded item...
tonco
1

votes
2

answer
324

Views

Using textacular gem, how do I match one word in a large body of text?

I have a rails (4.2.3) blog app with the textacular gem with a Post model having title:string and body:text. I create a post: > my_post = Post.create! title: 'my post', body: 'this post is about physics and ...' Now, I want the search for 'physics' to match the body, but it doesn't. If I try: > Post...
Anand
1

votes
1

answer
257

Views

how improve order by in search query? PostgreSQL

i need some help. site has 2 sort types: by relevancy and date. Sometimes happends that issues with most high score are to old, and the newest has small score. So needed some common query based on 2 marks. Relecancy query looks like 'ORDER BY' ts_rank(EXTENDED_INDEX, custom_tsquery('english', 'test...
1

votes
2

answer
890

Views

mysql full text search boolean mode with spaces

I have select for full text search SELECT * FROM datatable WHERE MATCH(field1, field2, field3, field4) AGAINST('C 100 330 00 75*' IN BOOLEAN MODE) C 100 330 00 75 in field2, in field1 the same data but without spaces C1003300075 , in field3 data like 'here we are', or 'delta star'. Select work for...
Armen Arzumanyan
1

votes
2

answer
237

Views

SQL Server Full Text Search matches part of a word, even without wildcard

Take this query: SELECT * FROM Books WHERE CONTAINS(([Description], ReverseDescription), ''øgle'') And these two text for the columns being search: http://textuploader.com/5bg5r http://textuploader.com/5bg59 Why does that one match? I cannot for find an exact match in either of those texts. And as...
1

votes
1

answer
215

Views

Using MATCH with AND/OR operators with parameters doesn't work in SQLite

I'm having problem with executing select statement while using match and and/or operators while using parameters. The statement looks like this: SELECT ColumnName1, ColumnName2 FROM TableName WHERE TableName MATCH 'ColumnName1:@param1 AND ColumnName2:@param2'; But when I change @param1 and @param2...
user2764266
1

votes
1

answer
409

Views

Optimizing Elasticsearch for Parallel Queries

I've got an index of about 3gb on a 20 node Elasticsearch cluster running in AWS EMR. The index has 5 shards and is replicated 4 times. The underlying data are books, but I've split them into paragraph or line chunks, depending on formatting, so there are about 27million documents. Indexing only tak...
econgineer
1

votes
1

answer
315

Views

PostgreSQL full text search: How to change what classifies as a “word separator”?

Using ts_debug I can see what symbols Postgres treats as (what I call) a 'word separator'. Example: SELECT ts_debug('english', 'Hello. ABC') Result: (asciiword,'Word, all ASCII',Hello,{english_stem},english_stem,{hello}) (blank,'Space symbols','. ',{},,) (asciiword,'Word, all ASCII',ABC,{english_st...
Leif
1

votes
1

answer
361

Views

Eclipse file search regular expression operation

I have strings like catApple, catBoy, catChild, ... catRobIsAGoodBoy, ... catZebraIsAnAnimal as class names in my application. Now I have to remove the cat prefix from all class names. Using File Search in Eclipse I can search for cat[A-Z] and that gives me all my matched class names (also ensuring...
Kumar
1

votes
1

answer
20

Views

Issue with FullText or LIKE search (unable to find inventory)

Having some trouble finding an item in my inventory when a user searches for something that I know is in the inventory. Table Columns are ManufacturerNameMatch, SubCategoryNameMatch, MainCategoryNameMatch, Model_Name When I search Nikon Ti-E the script can't seem to find it. However, I know that it...
soulglow1985
1

votes
1

answer
295

Views

Greek language support for lunr.js

Registering a new stemmer function in lunr for greek words doesn't work as expected. here is my code on codepen. I am not receiving any errors, the function stemWord() works fine when used separately but it fails to stem the words in lunr. below is a sample of the code: function stemWord(w) { // cod...
Miloš Miljković
1

votes
1

answer
393

Views

How do you match multiple text in multiple column in a table with SQLite FTS3?

I'm searching for Multiple text in multiple column of Virtual Table. I have checked this thread, this search for a single word in multiple column. I checked with following SELECT * FROM table WHERE table MATCH (('A:cat OR C:cat') AND ('A:dog OR C:dog') but it seems AND condition not working. EDIT I...
CoDe
1

votes
1

answer
119

Views

Configure sphinx to rank exact matching higher with morphology enabled

I'm having sphinx index to search users by names. I'm using soundex morphology to show more relevant results for case searcher doesn't exactly know how the name spells. Consider following table: +----+--------------------+ | id | name | +----+--------------------+ | 1 | Maciej Makusze...
Glen Swift
1

votes
4

answer
33

Views

Search query array value binding not working

I'm working on a search query and i hit a little bump... So as you see in the code below, i'm adding values to a array to execute it later in the script, but it's not really working... So when i var_dumped all of this, it returned like it is supposed to but the :q was not changed to the value which...
Adam K
1

votes
2

answer
290

Views

Looking for a Pattern 512 bytes at a time and printing match.

I need to find a string that matches a particular pattern in a very large log file (several GB). The problem is that I can only look at 512 bytes of the file at a time. As I compare the string 512 bytes at a time, the pattern isn't always found because it may overlap two different chunks. for exam...
Lexicon
1

votes
1

answer
181

Views

Can I use AND statements in FTS Query?

Is is possible to still enjoy the benefits of FTS3/4 in SQLite while executing a query with AND statements on indexed columns in a virtual table? Example: SELECT title, ID, creationDate FROM documents WHERE type=1 AND status=2 AND searchableFields MATCHES ''john doe''; OR SELECT title, ID, creationD...
user3367265
1

votes
2

answer
650

Views

How to perform “like” query with full text search in mongodb?

I know that mongo does not support $regex or like operation with full text search at the moment.It only matches the text or the phrase.But I need to perform like query search on indexed fields.So, I need help regarding the choice of multiple search frameworks or any other work around to solve this i...
oblivion
1

votes
1

answer
585

Views

CamelCase Search with Elasticsearch

I want to configure Elasticsearch, so that searching for 'JaFNam' will create a good score for 'JavaFileName'. I'm tried to build an analyzer, that combines a CamelCase pattern analyzer with an edge_ngram tokenizer. I thought this would create terms like these: J F N Ja Fi Na Jav Fil Nam Java File N...
slartidan
1

votes
1

answer
585

Views

Postgres 9.6.1 Full Text Search dictionaries for most spoken languages

I am trying to run full text search operations, such as to_tsvector, to_tsquery, etc and have a need for dictionaries in about 80+ languages. Postgres seems to only come with 16 language configurations, with an additional two I am testing for Chinese (jiebacfg and testzhcg aka ZHParse). I'm looking...
Growler
1

votes
1

answer
512

Views

PHP/SQL: Multiple fuzzy keyword search based on likeness (Advanced SQL Search)

Current Situation: I am currently running a keyword search using multiple keywords in PHP and SQL. The field I'm applying the search to is the title field, which is a 250 VARCHAR field. A user can input a single keyword, e.g. 'apple' or also multiple, e.g. 'apple banana yellow'. The first option is...
Jonas Kaufmann
1

votes
1

answer
105

Views

How to split a FULLTEXT index between multiple match against

I have the following full text index: FULLTEXT INDEX `title_short_description_description` (`title`, `short_description`, `description`) When I run the below query I get this error: Can't find FULLTEXT index matching the column list select ( (match (title) against ('abc' in boolean mode) * 100) + (m...
Get Off My Lawn
1

votes
1

answer
558

Views

Adding multiple phrases together in phraseto_tsquery

I have been successfully able to concat arrays of single words into strings for to_tsquery but phraseto_tsquery in postgres 9.6 only allows one keyword phrase. Does anyone know of a solution to query a tsvector (whether in Sql or full-text-search features) in such a way where I can (OR/AND) a dynami...
sizzle
1

votes
1

answer
320

Views

Neo4j: indexing properties that are longer then 32k with node_auto_index / lucene index

I am trying to build a little file and email search engine. I'd like also to use more advanced search queries for the full text search. Hence I am looking at lucene indexes. From what I have seen, there are two approaches - node_auto_index and apoc.index.addNode. Setting the index up works fine, an...
Joerg Baach
1

votes
2

answer
411

Views

Matching one or more keywords with Django's Postgres full-text searching

If I search on a website with multiple keywords (and no quotes) -- such as for red car -- my expectation is that items containing 'red car' exactly should be first, followed by items containing both keywords (but non-sequentially), followed by items containing one of the keywords. (I believe this is...
Dolan Antenucci
1

votes
2

answer
582

Views

MySQL index for normal column and full text column

I'm trying to speed up a query for the below: My table has around 4 million records. EXPLAIN SELECT * FROM chrecords WHERE company_number = 'test' OR MATCH (company_name,registered_office_address_address_line_1,registered_office_address_address_line_2) AGAINST('test') LIMIT 0, 10; +------+------...
Chris Stryczynski
1

votes
1

answer
32

Views

Elasticsearch - Show index-wide count for each returned result based from a given term

Firstly i apologise if the terminology i use is incorrect as i am learning elasticsearch day by day and maybe use incorrect phrases. After spending several days trying to figure this out and pulling my hair out i seem to be hitting brick walls every-time. I am trying to get elasticsearch to provide...
Birdy
1

votes
1

answer
233

Views

Calculate relevant result on full text search in mongodb

I am trying to get the more relevant results from mongo, let say that i have this collections { 'text' : 'mitsubishi lancer 2011'} { 'text' : 'mitsubishi lancer 2011'} { 'text' : 'mitsubishi lancer 2011 in good conditions'} { 'text' : 'lancer 2011'} { 'text' : 'mitsubishi lancer 2014'} { 'text' : 'l...
stalin
1

votes
2

answer
187

Views

hibernate search case insensitive search is not corretly work with LowerCaseFilterFactory

I have following configration for hibernate-search: @AnalyzerDef(name = 'autocompleteNGramAnalyzer', // Split input into tokens according to tokenizer tokenizer = @TokenizerDef(factory = StandardTokenizerFactory.class), filters = { // Normalize token text to lowercase, as the user is unlikely to //...
gstackoverflow
1

votes
1

answer
138

Views

How to fetch names of virtual tables?

Example schema: CREATE VIRTUAL TABLE posts USING FTS5(title, body); Select table names: SELECT name FROM sqlite_master WHERE type='table'; Result: posts posts_data posts_idx posts_content posts_docsize posts_config How to fetch result only for virtual tables, without *_data, *_idx, *_content, *_doc...

View additional questions