[support] Full-text data search in InnoDB tables

[Ursula Pieper]

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 at 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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120827/d70efcc0/attachment.html