full-text-search Questions
3
Solved
I know that Doctrine 2 doesn't support FULLTEXT indexes. I'm actually using a result set mapping and native queries to FULLTEXT search innodb tables (MySQL 5.6). But I still need to mark one or mor...
Vaporization asked 3/5, 2014 at 18:23
2
Solved
I have a question regarding this article: http://dev.mysql.com/doc/refman/5.6/en/fulltext-natural-language.html.
Here I found queries like
SELECT * FROM articles
WHERE MATCH (title,body)
AGAINST...
Sharasharai asked 16/5, 2013 at 14:53
2
I have full text index on text column of my table with around 11 million rows.
Table structure :
CREATE TABLE `review` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`comments` text COLLATE utf8mb4_un...
Clovah asked 12/9, 2017 at 9:24
2
Solved
I have a table containing one column and 100 million rows of text.
The text is simple 1 - 5 words sentences.
My goal is to have an ultra-fast query which could be used with an autocomplete. So t...
Demography asked 23/2, 2018 at 14:4
3
Solved
I understand that the asterisk is a wildcard that can be appended to the end of fulltext search words, but what if my searched keyword is a suffix? For example, I want to be able to search for "ame...
Ss asked 23/5, 2013 at 17:39
5
Solved
I am trying to optimize the search for a string in a large text file (300-600mb). Using my current method, it is taking too long.
Currently I have been using IndexOf to search for the string, but ...
Bankable asked 19/12, 2012 at 19:10
4
I am working on a project with a requirement of coming up with a generic dashboard where a users can do different kinds of grouping, filtering and drill down on different fields. For this we are lo...
Ratable asked 24/4, 2015 at 7:32
1
Solved
I am attempting to make use of SQLite's full text search (FTS) extension in an external content table by following the official documentation. I am running sqlite version 3.42.0 from the Arch linux...
Monkeypot asked 26/5, 2023 at 16:57
4
I'm designing a fulltext search function in postgresql for my current project.
It works ok with ispell/myspell dictionaries so far.
Now I need to add support for chinese, japanese and arabic search...
Pickering asked 22/3, 2010 at 21:44
3
Solved
TL;DR
How/why are some browsers able to search and highlight text in the HTML body which is followed by #:~:text= in the URL?
Explanation
One day I was searching for something on Google, which lea...
Outmost asked 20/7, 2020 at 5:19
6
Solved
I am using Visual Studio. Say for instance I have a static public method named FooBar() in class Utils. Let's also say that I use this method in a lot of .aspx files. Let's say I change the method ...
Foreshank asked 14/8, 2014 at 14:26
3
Solved
I have this Full-Text-Search function:
CREATE OR REPLACE FUNCTION search_questions(psearch text)
RETURNS TABLE (questionid INTEGER) AS $func$
BEGIN
return QUERY
SELECT DISTINCT (questions.publi...
Joviality asked 27/4, 2017 at 23:9
2
Solved
I have the following WHERE clause:
WHERE (@Keywords IS NULL
OR (CONTAINS((p.Title, p.Area, p.[Message]), @Keywords))
)
If @Keywords = 'control', then the query executes successfully and filter...
Inwardness asked 24/2, 2012 at 17:19
2
Solved
I have a scenario, where I have data for informal communications that I need to be able to search. Therefore I want full text search, but I also to make sense of spelling mistakes. Question is how ...
Jagannath asked 21/1, 2020 at 15:3
2
Solved
Let's say we have the following query:
SELECT *
FROM companies
WHERE name LIKE '%nited'
It returns
name
united
How do I write a query using MySQL's full-text search that will provide s...
Cobnut asked 19/12, 2013 at 10:51
3
Solved
I've started learning Django very recently, so please forgive me if this is too newbie a question for you.
I have a search function implemented in Django. I created in MySQL DB full-text-index and...
Dingus asked 2/4, 2014 at 1:30
2
I want to create an autocomplete input box that shows word suggestions as users type.
Basically, my problem is that when I use the $text operator for searching strings in a document, the queries ...
Conformance asked 27/8, 2015 at 20:38
2
I read that it is possible to compress sqlite databases with extensions like sqlite-zstd.
In Sqlite3, are there methods, ready to use in Python, that allow both:
compression of a text column (let'...
Windsucking asked 15/10, 2022 at 10:13
4
Solved
HotKey: Shift+Ctrl+F
Correct result:
Error results,
you can find the results just show as '<binary>'.I've searched this problem in google,but get nothing,
Here is log text.
Thanks for an...
Mutton asked 25/9, 2014 at 3:50
2
I have been searching for a blog post or a feature matrix which compares MySQL and PostgreSQL by their JSON capabilities. I found a good feature matrix for Postgres but not for MySQL. Also there ar...
Trueman asked 3/1, 2017 at 12:54
2
Solved
These two features look pretty simmilar, but Atlas Search is fresh and maybe more powerfull.
Is Atlas Search a replacement for Text Indexes in MongoDb? Will Text Indexes be deprecated?
Did I missed...
Elswick asked 23/7, 2020 at 13:55
1
After parsing many documents, I have a lot of rows/columns with Ukrainian text that should be indexed for full-text search in Postgres.
I've found that Postgres 14 supports by default 29 languages,...
Poteet asked 30/9, 2022 at 10:22
4
Solved
I need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for anywhere that the developers used MAX + 1 instead of the NEXTVAL on the sequence to get the ...
Meerschaum asked 17/2, 2011 at 19:48
5
Solved
When entering a question, stackoverflow presents you with a list of questions that it thinks likely to cover the same topic. I have seen similar features on other sites or in other programs, too (H...
Stringendo asked 16/9, 2008 at 9:4
3
Solved
I see that Neo4j have Indexes to support full-text search. But I can't find examples in the documentation on how to use this ability with regular relations query.
For example, I have the following...
Anticlimax asked 14/4, 2019 at 11:20
© 2022 - 2024 — McMap. All rights reserved.