full-text-search Questions
4
Solved
I have about 2000 rows in a mysql database.
Each row is a max of 300 characters and contains a sentence or two.
I use mysql's built in fulltext search to search these rows.
I would like to add a...
Scalawag asked 26/8, 2011 at 6:42
4
I have full text search on my database.
Is it possible to search in the middle of a word for some text?
For example, I have a column Description that contains the following text:
Revolution
Is...
Crimpy asked 5/7, 2011 at 16:3
2
Solved
I am using Laravel 4 and have set up the following query:
if(Input::get('keyword')) {
$keyword = Input::get('keyword');
$search = DB::connection()->getPdo()->quote($keyword);
$query->w...
Pestana asked 22/10, 2014 at 12:6
4
Solved
New to Android Studio and I wanted to find all instances of something across all java files. I read that shift+shift would bring up a 'Search Everywhere' box but it doesn't work. You can see from t...
Newfashioned asked 10/3, 2015 at 0:48
5
Solved
Okay, so I'm trying to make a full text search in multiple columns, something simple like this:
SELECT * FROM pages WHERE MATCH(head, body) AGAINST('some words' IN BOOLEAN MODE)
Now i want to or...
Lur asked 7/6, 2011 at 0:56
1
Solved
I am trying to create an index for text search in Postgres, but I keep getting an error when I create generated tsvector column.
ERROR: generation expression is not immutable
SQL state: 42P17
I ha...
Keri asked 10/8, 2021 at 18:23
9
Solved
I'm building a Django site and I am looking for a search engine.
A few candidates:
Lucene/Lucene with Compass/Solr
Sphinx
Postgresql built-in full text search
MySQl built-in full text sear...
Moazami asked 10/4, 2009 at 10:38
6
Solved
We can search files in windows 7 or higher version using the following tool:
(I don't have image uploading privilage. I mean the top-right area in windows file explorer.)
When I search fo...
Towny asked 21/5, 2015 at 5:3
4
Solved
I'm attempting to find the number of matches for a given string across a large project. Currently, to do this with ag I am using the following command:
$ echo 0$(ag -c searchterm | sed -e "s/^.*:...
Paolapaolina asked 13/8, 2015 at 18:28
6
I am looking for a function like strpos() with two significant differences:
To be able to accept multiple needles. I mean thousands of needles at ones.
To search for all occurrences of the ...
Graphemics asked 1/8, 2011 at 9:38
5
I have a query that ran fine on SQL2005 but moving the database to SQL2008 gives me the error from the title.
The code that is the problem is a call to CONTAINS, CONTAINSTABLE or FREETEXT with an ...
Ebracteate asked 10/10, 2008 at 0:58
4
Solved
What exactly is faceted search in the context of full-text search?
I even read about it from Wikipedia, but I couldn't completely understand the use/benefit of it. Hope the community can answer/exp...
Splotch asked 16/3, 2011 at 5:58
2
Solved
I have observed what seems to me an odd behavior of Postgres' to_tsvector function.
SELECT to_tsvector('english', 'abc-xyz');
returns
'abc':2 'abc-xyz':1 'xyz':3
However,
SELECT to_tsvector(...
Earthenware asked 4/9, 2019 at 19:58
1
Solved
I am trying to apply partial search in Django postgres, exactly the same as described here django-text-search-with-partial-sentence-match
I found there a pretty nice solution
from psycopg2.extensio...
Androgen asked 29/1, 2021 at 9:2
2
How can I search for code fragments on github.com? When I search for MSG_PREPARE in the repository ErikZalm/Marlin github shows up nothing.
I'm using the repository code search syntax described o...
Blindage asked 10/11, 2012 at 12:12
2
Solved
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 firstly what determines the expansion o...
Eurystheus asked 4/9, 2019 at 13:53
2
I'm using Django Full Text search to search across multiple fields but have an issue when searching using partial strings.
Lets say we have a report object with the name 'Sample Report'.
vector =...
Patsypatt asked 4/8, 2017 at 23:10
4
There are quite a lot of tools to extract text from PDF files[1-4]. However the problem with most scientific papers is the hardship to get access PDF directly mostly due to the need to pay for them...
Polyphagia asked 18/6, 2015 at 0:43
2
Solved
I am writing a newsletter script and I need to implement searching in the addresses. I indexed the table with FULLTEXT but when I do a query such as:
SELECT * FROM addresses WHERE MATCH(email) AGA...
Justinejustinian asked 22/1, 2012 at 12:45
2
Solved
I am currently attempting to create a full text index on a unique column. The table definition is:
CREATE TABLE [dbo].[DictionaryWords](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Word] [varchar](255) ...
Poindexter asked 22/11, 2017 at 14:56
1
I set up an external content FTS4 virtual table in my app to allow full text search of an existing database. I also set up triggers similar to the documentation, so when my main content table is up...
Appomattox asked 9/1, 2014 at 16:43
7
Solved
I want to make a text search case insensitive with regex query with spring-data mongo .
For example in Oracle :
select * from user where lower(username) like '%ab%'
How can i make this query w...
Gerik asked 19/1, 2017 at 16:3
2
Is it possible to create a full text index on a VIEW?
If so, given two columns column1 and column2 on a VIEW, what is the SQL to get this done?
The reason I'd like to do this is I have two very l...
Tetravalent asked 15/3, 2011 at 3:12
4
Solved
If I run this query and print the score of each rows, they are always 1:
Here are some sample query results:
First | Last | Score
------------------------------
Jonathan | Bush | 1
Joshua | Gilbe...
Despairing asked 3/7, 2011 at 10:52
4
Solved
I'm using Aho-Corasick text matching and wonder if it could be altered to match terms instead of characters. In other words, I want the the terms to be the basis of matching rather than the charact...
Rusel asked 21/1, 2013 at 18:12
© 2022 - 2024 — McMap. All rights reserved.