Stack Overflow
Stack Overflow

Questions tagged [full-text-search]

Full text search involves searching documents, usually involving unstructured text, as opposed to searching text fields in a structured database.

Full text search involves searching documents, usually involving unstructured text, as opposed to searching text fields in a structured database.

Full text search capabilities often include ranking of results by relevance, similarity matching, boolean queries, text clustering, and more.

Popular Full-text Search Tags

Popular Full-text Search Tags related to Open Source solutions.

7909 questions
27
votes
5 answers

MongoDB fulltext search + workaround for partial word match

Since it is not possible to find "blueberry" by the word "blue" by using a mongodb full text search, I want to help my users to complete the word "blue" to "blueberry". To do so, is it possible to query all the words in a mongodb full text index ->…
KIC
  • 5,887
  • 7
  • 58
  • 98
26
votes
6 answers

Full text search vs LIKE

My question is about using full text search. As I know like queries which begin with % never use index : SELECT * from customer where name like %username% If I use fulltext for this query can I take better performance? Can SQL Server use fulltext…
profvm
  • 261
  • 1
  • 3
  • 3
26
votes
2 answers

MySQL vs PostgreSQL JSON search features

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 are a bunch posts like this which compare the two but…
SlideM
  • 461
  • 5
  • 13
26
votes
2 answers

MySQL FULLTEXT not working

I'm attempting to add searching support for my PHP web app using MySQL's FULLTEXT indexes. I created a test table (using the MyISAM type, with a single text field a) and entered some sample data. Now if I'm right the following query should return…
Ross
  • 46,186
  • 39
  • 120
  • 173
26
votes
3 answers

Order SQL by strongest LIKE?

I have the following query: SELECT * FROM table_name WHERE (col_1 LIKE '%$keyword%' OR col_2 LIKE '%$keyword%' OR col_3 LIKE '%$keyword%') AND .... ... is there a strategy to sort based on the most relevant…
Shazam
  • 689
  • 2
  • 9
  • 17
26
votes
2 answers

Why doesn't SQL Full Text Indexing return results for words containing #?

For instance, my query is like the following using SQL Server 2005: SELECT * FROM Table WHERE FREETEXT(SearchField, 'c#') I have a full text index defined to use the column SearchField which returns results when using: SELECT * FROM Table WHERE…
Geoff Dalgas
  • 6,116
  • 6
  • 42
  • 58
26
votes
1 answer

Express with Advanced Services, can't create Full Text Index

I have installed SQL Server 2012 Express Edition Advanced Services which states that it includes Full-text indexing. Here is a link that states this: http://msdn.microsoft.com/en-us/library/cc645993.aspx I have confirmed that Full-text service is…
TreK
  • 1,144
  • 2
  • 13
  • 25
25
votes
6 answers

strpos() with multiple needles?

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 needles in the haystack and to return an array of starting…
Nikola Obreshkov
  • 1,698
  • 4
  • 21
  • 32
25
votes
8 answers

Full Text Search in Linq

There's no full text search built into Linq and there don't seem to be many posts on the subject so I had a play around and came up with this method for my utlity class: public static IEnumerable GenericFullTextSearch(string text,…
ctrlalt3nd
  • 1,352
  • 3
  • 13
  • 18
25
votes
1 answer

FullText search with CONTAINS on multiple columns and predicate - AND

I have a search table with, say, 4 columns of text data to search. I do something like this: SELECT * FROM dbo.SearchTable WHERE CONTAINS((co1, col2, col3, col4), 'term1 AND term2') It looks like Contains only returns true if term1 and term2 are in…
user3083558
24
votes
10 answers

Full-text search in NoSQL databases

Has anyone here have any experience deploying a real online system that had a full text search in any of the NoSQL databases? For example, how does the full-text search compare in MongoDB, Riak and CouchDB? Some of the metric that I am looking…
unj2
  • 52,135
  • 87
  • 247
  • 375
24
votes
7 answers

Spring Data mongo case insensitive like query

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 with spring-data mongo ? Thanks in advance
akinKaplanoglu
  • 728
  • 2
  • 8
  • 26
24
votes
2 answers

MySQL full text search with partial words

MySQL Full Text searching appears to be great and the best way to search in SQL. However, I seem to be stuck on the fact that it won't search partial words. For instance if I have an article titled "MySQL Tutorial" and search for "MySQL", it won't…
Rob
  • 273
  • 1
  • 2
  • 5
24
votes
3 answers

Escaping special characters in to_tsquery

How do you espace special characters in string passed to to_tsquery? For instance, this kind of query: select to_tsquery('AT&T'); Produces: NOTICE: text-search query contains only stop words or doesn't contain lexemes, ignored to_tsquery…
Konrad Garus
  • 53,145
  • 43
  • 157
  • 230
24
votes
3 answers

How to create client side full text search engine with pure JavaScript and HTML5?

I need to create client side search engine for an offline html application in offline storage like CDROM. I already create it with Win32 and the catalog file is near 2GB (MDB file). My offline web application use CEF (Chromium Embedded Framework)…
Mohammad Nikravan
  • 1,543
  • 2
  • 19
  • 22
1 2 3
…
99 100