full-text-search Questions
6
Solved
I need to write some sql that will allow me to query all objects in our Oracle database. Unfortunately the tools we are allowed to use don't have this built in.
Basically, I need to search all tabl...
Garb asked 12/5, 2009 at 16:1
3
Solved
I need to find if items from a list appear in a string, and then add the items to a different list. This code works:
data =[]
line = 'akhgvfalfhda.dhgfa.lidhfalihflaih**Thing1**aoufgyafkugafkjhafkj...
Tavel asked 5/10, 2020 at 19:9
1
I have a database of products which I do a full-text search on using pg_search Gem. The query looks something like this:
SELECT "products".* FROM "products" WHERE (((to_tsvector('english', coalesc...
Muzzleloader asked 19/5, 2015 at 6:0
3
Solved
Is there a way to get the StopWord list that my SQL Server 2008 FullText Catalog is using?
And use it, in my C# codebehind?
I want to use it in a ASP.NET page that I use to search terms and highli...
Elyse asked 11/2, 2011 at 19:6
4
Solved
I've been using elasticsearch as a search engine for my Rails application, however it stopped working properly due to a reason i can't understand. When making a curl request to elasticsearch server...
Jerejereld asked 3/9, 2013 at 9:40
4
Solved
I am using the fts4 extension of sqlite3 to enable full-text indexing and searching of text data. This it working great, but I've noticed that the results are not relevance-ranked at all. I guess I...
Subastral asked 1/9, 2011 at 14:44
3
Solved
I'm trying to perform a full-text search on an array of strings in Mongoose and I am getting this error:
{ [MongoError: text index required for $text query]
name: 'MongoError',
message: 'text in...
Electrodynamic asked 25/11, 2016 at 14:10
3
Solved
Does Android come with a way to do Full Text Search?
I know is it not even possible to search contacts by the notes field, being Google the search company, but I would be disappointed if there is ...
Donkey asked 29/12, 2009 at 19:8
3
Solved
If I have the following full text search query:
SELECT *
FROM dbo.Product
INNER JOIN CONTAINSTABLE(Product, (Name, Description, ProductType), 'model') ct
ON ct.[Key] = Product.ProductID
Is it ...
Petry asked 6/7, 2011 at 19:6
6
I need to implement full text search for my Django application, running MySQL as backend.
Let's say I've got a model as follows:
class MyItem(models.Model):
title = models.CharField()
short_des...
Kubis asked 12/2, 2010 at 0:8
9
Solved
I'm developing a high-volume web application, where part of it is a MySQL database of discussion posts that will need to grow to 20M+ rows, smoothly.
I was originally planning on using MyISAM for ...
Woodrum asked 4/9, 2009 at 19:42
3
Solved
PyCharm's Search Everywhere functionality easily allows the user to search everywhere for source code in every file of the project. However it is not able to search for comments, is there a way aro...
Westering asked 16/3, 2016 at 13:7
4
Solved
Right now I have a products collection where I store my products as documents like the following:
documentID:
title: STRING,
price: NUMBER,
images: ARRAY OF OBJECTS,
userImages: ARRAY OF OBJECTS,...
Estevan asked 3/6, 2019 at 13:41
1
Solved
I used this SO question to enable full text search on a mysql db in Django application.
# models.py
class CaseSnapshot(BaseModel):
text = models.TextField(blank=True)
class Search(models.Looku...
Bengal asked 28/4, 2020 at 17:51
6
Solved
Can anyone point me to a tutorial.
My main experience with Solr is indexing CSV files. But I cannot find any simple instructions/tutorial to tell me what I need to do to index pdfs.
I have seen t...
Farnese asked 14/7, 2011 at 13:57
2
Solved
I need to customize Full-text search for Persian language. And customize Stop/Noise words and synonyms for this language.
My SQL Server version is 2016 and full-text search is installed.
Cryptoclastic asked 19/2, 2020 at 5:47
9
Solved
I am trying to understand what shard and replica is in Elasticsearch, but I didn't manage to understand it. If I download Elasticsearch and run the script, then from what I know I have started a cl...
Gubernatorial asked 29/3, 2013 at 0:55
4
Solved
Say I indexed the following from my database:
======================================
| Id | Code | Description |
======================================
| 1 | A1 | Hello world |
| 2 | A1 | Hello wo...
Pierrepierrepont asked 29/11, 2010 at 10:15
2
Solved
I'm trying to set the Full Text property for some columns within a table in a MySQL InnoDB database.
I can't find the option on MySQL Workbench and I've tried various searches on Google to find o...
Cupidity asked 6/8, 2013 at 22:0
5
Solved
I'm working with fulltext, I executed an command to add the fulltext index to multiple comments, and returned no errors, then I did:
SELECT * FROM products WHERE MATCH(`brand`) AGAINST('Skoda');
...
Topknot asked 13/3, 2012 at 8:21
3
We're developing a search as a part of a bigger system.
We have Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Standard Edition (64-bit) with this setup:
CREATE TABLE NewCompanies(
[Id] [uniquei...
Psid asked 18/2, 2020 at 9:8
6
Solved
I'm preparing to deploy a Rails app on Heroku that requires full text search. Up to now I've been running it on a VPS using MySQL with Sphinx.
However, if I want to use Sphinx or Solr on Heroku, I...
Anselmi asked 4/6, 2012 at 2:23
1
Solved
In the Microsoft SQL Server, our searches are limited to starting words when we use a full-text search to search for values. That is, we cannot search contains the word looks like the LIKE operator...
Satisfaction asked 16/2, 2020 at 12:44
2
Solved
I want to search for a word in documents I have stored in Elasticsearch 7.3
An example of what I would like on previous versions of Elasticsearch that worked is:
{
"query": {
"bool": {
"must":...
Quite asked 15/8, 2019 at 22:6
2
I need to do a Fulltext search for a whole bunch of values out of a column in another table. Since MATCH() requires a value in the AGAINST() part, a straightforward: "SELECT a.id FROM a,b WHERE MAT...
Norvun asked 6/1, 2010 at 7:25
© 2022 - 2024 — McMap. All rights reserved.