MySQL's full text support for InnoDB is highly new. You have to be running MySQL 5.6.4+. MySQL 5.6 is still in dev, so unless you are on a dedicated server, VPS or Cloud and want to get really risky with your data, you are going to have to wait.

Jamie Holly
http://www.intoxination.net 
http://www.hollyit.net

On 8/27/2012 8:30 PM, Kamal Palei wrote:

Hi Ursula

Thank for reply.

 

I know with 'like' query will work.

But you know, 'like' is not preferred from perfroamance perspective as well sometimes it may not give expected result (example %man% may return "woman" etc..).

 

I am looking at if somebody enters words with minor spell mistake, still our search should pick the right word.

Lets say in my table, I have a key word "session initiation protocol". If somebody searches "sesson initiaton protocol", still I should be able to pick the right key word.

 

To acheive above, there should be some way out, since me a newbie in database just was looking how experts do these with innodb tables.

 

Best Regards

Kamal

NECS, Bangalore

On Tue, Aug 28, 2012 at 5:51 AM, Ursula Pieper <dramamezzo@gmail.com> wrote:

Hi Kamal,

Did you try the following query:

select * from resubmt_skill_ids where name like "%java%";

Did  I understand you correctly, and this is what you are looking for?

Ursula

On Mon, Aug 27, 2012 at 5:43 AM, Kamal Palei <palei.kamal@gmail.com> wrote:

Hi All

I am using Drupal 6.26, MySql (innodb).

 

I tried to first to do full text data search in InnoDB table.

A simple query statement is shown as below.

 

SELECT * FROM resubmt_skill_ids WHERE MATCH (name) AGAINST ('java')

 

But I get the below error.

 

#1214 - The used table type doesn't support FULLTEXT indexes

 

On further google search, came to know, only MyISAM type tables support full-text search.

I am bit reluctant to change my tables from InnoDB to MyISAM.

Can somebody suggest me is it not possible to do full-text search in InnoDB tables.

Came across http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/ have not gone completely, but it looks author tells full-text search possible with innodb tables.

 

If anybody has used full-text search on innodb tables, please let me know, how to do that from drupal perspective .

 

Best Regards

Kamal

NECS, Bangalore

 

 

 

 

 

 

 

 

 

--
[ Drupal support list | http://lists.drupal.org/ ]

--
[ Drupal support list | http://lists.drupal.org/ ]

--
[ Drupal support list | http://lists.drupal.org/ ]