[support] Full-text data search in InnoDB tables

[Kamal Palei]

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 at 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 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/ ]
>>
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120828/4bdb3741/attachment.html