Hi Kamal, <br><br>Did you try the following query:<br><br>select * from resubmt_skill_ids where name like "%java%";<br><br>Did I understand you correctly, and this is what you are looking for? <br><br>Ursula<br>
<br><div class="gmail_quote">On Mon, Aug 27, 2012 at 5:43 AM, Kamal Palei <span dir="ltr"><<a href="mailto:palei.kamal@gmail.com" target="_blank">palei.kamal@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>Hi All</div>
<div>I am using Drupal 6.26, MySql (innodb).</div>
<div> </div>
<div>I tried to first to do full text data search in InnoDB table.</div>
<div>A simple query statement is shown as below.</div>
<div> </div>
<div><b>SELECT * FROM resubmt_skill_ids WHERE MATCH (name) AGAINST ('java')</b></div>
<div> </div>
<div>But I get the below error.</div>
<div> </div>
<div>#1214 - The used table type doesn't support FULLTEXT indexes</div>
<div> </div>
<div>On further google search, came to know, only MyISAM type tables support full-text search.</div>
<div>I am bit reluctant to change my tables from InnoDB to MyISAM. </div>
<div>Can somebody suggest me is it not possible to do full-text search in InnoDB tables.</div>
<div>Came across <a href="http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/" target="_blank">http://blogs.innodb.com/wp/2011/07/innodb-full-text-search-tutorial/</a> have not gone completely, but it looks author tells full-text search possible with innodb tables.</div>
<div> </div>
<div>If anybody has used full-text search on innodb tables, please let me know, how to do that from drupal perspective .</div>
<div> </div>
<div>Best Regards</div>
<div>Kamal</div>
<div>NECS, Bangalore</div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<div> </div>
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>