FAQ Database Discussion Community


MySql Fulltext search using 2 character word

mysql,full-text-search,full-text-indexing
I've set ft_min_word_len = 1 and running show variables like 'ft%'; also shows the same. Also have already updated the Fulltext indexes by dropping and re-creating them. But when I run SELECT OriginalProductName FROM products WHERE MATCH (ProductName) AGAINST ('+samsung +tv' IN BOOLEAN MODE); against a row which is having...

Database column based record filtering not working using auto-complete search PHP

php,mysql,search,full-text-search,full-text-indexing
I have integrated auto-complete search in my site where user enter keyword and view the records based on it. Suppose, if I write zip code it only filter data from zip field. Next, if user types address like 121 North West, so script automatically pick records matches 121 North West....

How do I add a column to an existing FULLTEXT index?

php,mysql,innodb,full-text-indexing
I created a FULLTEXT index on a table in a MySql database, and left out a column when I did so. I have been trying to figure out how to add this column so that it can be searched against along with the other columns in this table that have...

MySql MyIsam table with fulltext search wildcard

mysql,wildcard,myisam,full-text-indexing
I created two tables with two different storage engines with same columns: table1(id,col1,col2) MyIsam table2(id,col1,col2) innodb every table contain according 1700000 I created full text index for (col1,col2) in the 2 tables I have 2 keywords that I need to extract results containing them: 'school' and 'bus' I am using...

What is the difference between FULLTEXT and FULLTEXT KEY/INDEX?

mysql,full-text-indexing
MySQL documentations gives this format for creating a FULLTEXT index: | {FULLTEXT|SPATIAL} [INDEX|KEY] [index_name] (index_col_name,...) [index_option] To implement full-text search with MySQL you can either create index by writing : CREATE TABLE posts ( id int(4) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, content text, PRIMARY KEY (id), FULLTEXT (title,...

How to create a fulltext index on array attributes?

full-text-indexing,arangodb
I'd like to create a fulltext index for an array attribute without needs to redundantly copy all its strings. I tried by defining an index for "attrib[*].string" but this does not work. Am I using the wrong syntax? If not, is it hard to support such an index scenario? For...

MySQL using OR with MATCH AGAINST slows query drastically

mysql,performance,full-text-search,sql-like,full-text-indexing
Columns are indexed and fulltext. Why does the "OR" add 5-8 seconds? SELECT * FROM exampleTable WHERE MATCH(someColumn) AGAINST('+testing123*' IN BOOLEAN MODE) // returns in .05 seconds SELECT * FROM exampleTable WHERE someColumn LIKE 'testing123%' // returns in .003 seconds SELECT * FROM exampleTable WHERE (MATCH(someColumn) AGAINST('+testing123*' IN BOOLEAN MODE)...

Why can't I MATCH() AGAINST() one of the columns in my FULLTEXT index?

mysql,full-text-indexing
Here's the CREATE TABLE: CREATE TABLE `EntityAddresses` ( `EntityAddress_ID` int(11) NOT NULL AUTO_INCREMENT, `Entity_ID` int(11) NOT NULL, `CreateDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `CreatedBy` int(11) NOT NULL, `UpdateDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `UpdatedBy` int(11) NOT NULL, `StreetAddress` varchar(150) NOT NULL DEFAULT '', `StreetAddress2` varchar(150) NOT NULL DEFAULT...

MongoDB - Logical OR when searching for words and phrases using full text search

mongodb,search,full-text-search,mongodb-query,full-text-indexing
I asked a related question previously, and as suggested by the poster there have created this new question as a follow up: MongoDB full text search - matching words and exact phrases I was having some problems with unexpected results when using the full text search functionality in MongoDB, specifically...

Document Storage with Full Text Indexing - PDF

java-ee,pdf,indexing,ocr,full-text-indexing
We have built an application for indexing submitted documents in many formats, spanning across Microsoft Office to text. The issue is that, for pdf, we often resort to converting to Word, then indexing. This is a slow process and problematic especially because it doesn't handle image-based pdfs where an OCR...