full-text-search Questions
3
Solved
I'm working on a document storage. Therefore I plan to use SqlServer 2012 with file tables.
Now after some tests it seems like the SqlServer only indexes doc and not docx files.
I also installed t...
Haplography asked 1/4, 2012 at 11:10
2
I have items table of online store, which has fulltext index on item_title, item_description, item_category columns. I would like to write search script, but having problem with deciding in which m...
Chaunce asked 11/3, 2013 at 19:4
3
I'm thinking about copying my text searchable content to Google's BigQuery and then perform full-text search using BigQuery API.
Does Google BigQuery support that scenario?
I could not find "sear...
Arytenoid asked 29/6, 2012 at 15:43
0
I'm using utf8mb4_bin for title column so i expected it's fulltext case-sensitive search. But actually the query return empty.
CREATE TABLE `test_table` (
`id` int NOT NULL AUTO_INCREMENT,
`title` ...
Reconstructionism asked 26/5, 2022 at 8:3
4
I have SQL Server 2008 R2 and am trying to implement full-text search on a PDF BLOB.
I have installed the iFilter from Adobe and confirmed it is installed
Using
EXEC sp_help_fulltext_system_com...
Paulinapauline asked 12/11, 2013 at 9:45
4
Solved
I need to provide full text search on javascript source files and highlighting of results.
My question is what combination of existing ElasticSearch tokenizers and analyzers would be best for this...
Leoleod asked 17/10, 2011 at 17:18
3
I am programing a Mongo query builder and I found two statements in documentation:
(Text search) The $match stage that includes a $text must be the first stage in the pipeline.
(Geo search) You ca...
Shanly asked 23/3, 2014 at 19:33
7
Solved
Full-Text search in Cassandra;
I am fairly new to Cassandra, and wish to understand it more properly. I am attempting to perform a Full-Text search in Cassandra, but after some research I have fou...
Consumable asked 21/7, 2014 at 5:18
7
Solved
I will be delivering a set of static HTML pages on CD-Rom; these pages need to be fully viewable with no Internet access whatsoever.
I'd like to provide a full-text search (Lucene-like) for the co...
Beeson asked 31/8, 2009 at 12:12
2
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%'
Oracle throws some error on it.
...
Blancheblanchette asked 2/1, 2011 at 10:23
1
Solved
I have enabled full text search for prisma and I would like to search the email field returning all entries that match.
I got the following code:
const data = await this.prismaService.merchant.find...
Recognition asked 16/4, 2022 at 10:14
3
I have a table like this
CREATE TABLE jobs(
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT (title,body)
) ENGINE=MyISAM;
And two records in this...
Hesky asked 27/3, 2012 at 15:57
5
Solved
I'm trying to run a very simple query on my MySQL INNODB table:
SELECT *
FROM items
WHERE MATCH (item_title,item_description) AGAINST ('dog')
Both column item_title and item_description have a...
Expressly asked 25/8, 2015 at 9:33
1
Using Postgres, I want to perform a full text search that includes an array column, using an index. Let's start with a hypothetical schema:
CREATE TABLE book (title TEXT, tags TEXT[]);
-- tags are ...
Occasionally asked 4/3, 2022 at 17:53
5
I want to implement MySQL full text search with sequelize. The version "sequelize": "^3.23.6". I tried to research about this but could not find =the documentation that guides how to implement this...
Montymonument asked 24/8, 2016 at 12:40
15
Solved
How could I search the contents of PDF files in a directory/subdirectory? I am looking for some command line tools. It seems that grep can't search PDF files.
Spelldown asked 10/1, 2011 at 3:23
2
I'm using typeorm to connect on mongodb,
Is typeorm support sort on relevant score return from full text search mongodb?
Like described here.
from mongo, i want to make query as:
db.todos.find( {$t...
Amanita asked 30/8, 2020 at 8:20
2
In PostgreSQL, how can one efficiently do a full text search on one column, sorting on another column?
Say I have a table tbl with columns a, b, c, ... and many (> a million) rows. I want to do ...
Idolism asked 6/11, 2021 at 1:56
2
Solved
I've developed an index and search application with Lucene library. but this library has some limitation in custom ranking in my context, aside from its performance, i need scalability and access t...
Zink asked 8/11, 2010 at 13:34
3
Solved
I'm trying to find "the zen" string in a field containing "The Zen Circus".
I've got a FULLTEXT index.
select url,name,
, MATCH(name) AGAINST ( 'zen*' IN BOOLEAN MODE) as A
, MATCH(name) AGAINST (...
Ultracentrifuge asked 24/10, 2012 at 12:33
2
Solved
I need to perform a ranking query using postgresql full-text search feature and Django with django.contrib.postgres module.
According to the doc, it is quite easy to do this using the SearchRank c...
Finite asked 6/1, 2017 at 14:32
4
I would like to know whether full text search in PostgreSQL 9.3 with GIN/GiST index uses tf-idf (term frequency-inverse document frequency).
In particular, in my columns of phrases, I have some w...
Hokeypokey asked 18/8, 2013 at 6:44
11
Solved
This seems like such a basic task, but I'm stumped.
How, in Xcode, do you execute a textual search though (the XML contents of) all the .xib files in a project?
For example, all of our .xib files...
Janeejaneen asked 18/10, 2010 at 21:3
2
Solved
I am using System.Data.SQLite.dll 1.0.101.0 and I get this error when execute the command "CREATE VIRTUAL TABLE tbl_fts USING fts5 (fld1, fld2)".
error:
no such module: fts5
in this page we can s...
Redound asked 1/6, 2016 at 9:59
3
Solved
I am looking into PostgreSQL full text search and would like to know if it is possible to search for the second part of compound words.
It there a way to get 'Cheesecake' as a result when I search ...
Fastness asked 15/7, 2021 at 23:25
© 2022 - 2024 — McMap. All rights reserved.