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/ ]