I'm looking to run a query that will return a list of columns in a table that are FULLTEXT indexed. The table is in MyISAM format and i'll be using php to construct the query. Ideally i would run ...

We are writing unit tests for our ASP.NET application that run against a test SQL Server database. That is, the ClassInitialize method creates a new database with test data, and the ClassCleanup d...

I'm working on a document storage. Therefore I plan to use SqlServer 2012 with file tables. Now after some tests it seems like the SqlServer only indexes doc and not docx files. I also installed t...

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 ta...

Hi I am looking for a query that is able to find Full text indexing on all tables and columns within a database using SQL Server 2008. Any information or help that can be provided for this is welco...

Let's say I have a mongo collection with a text index on the itemName field with these 3 documents: { _id: ..., itemName: 'Mashed carrots with big carrot pieces', price: 1.29 }, { _id: ..., i...

I changed to "ft_min_word_len" = 4 by my-innodb-heavy-4G.ini located in my system path "C:\Program Files\MySQL\MySQL Server 5.1" , but when i run SHOW VARIABLES LIKE 'ft_min_word_len' I got sti...

Working now on a vBulletin board, which runs on MySQL 5.6.21 with InnoDB table engine. There is a default query in vBulletin, which uses index hint on one column and the same time uses fulltext ind...

I have a table named 'fact' with title column, that should be full text index. Firstly, I add a full text index: ALTER TABLE fact ADD FULLTEXT title_fts (title) So, I insert row: INSERT INTO f...

I have created a fulltext catalog that stores the data from some of the columns in a table, but the contents seem to have been split apart by characters that I don't really want to be considered wo...

what exactly is the difference (and advantages/disadvantages) between a fulltext index and a regular index on a varchar column? When would I use which index? I have a multitude of varchar columns ...