<div>Hi Ursula</div>
<div>Thank for reply.</div>
<div> </div>
<div>I know with 'like' query will work.</div>
<div>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..).</div>
<div> </div>
<div>I am looking at if somebody enters words with minor spell mistake, still our search should pick the right word.</div>
<div>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.</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Best Regards</div>
<div>Kamal</div>
<div>NECS, Bangalore<br><br></div>
<div class="gmail_quote">On Tue, Aug 28, 2012 at 5:51 AM, Ursula Pieper <span dir="ltr"><<a href="mailto:dramamezzo@gmail.com" target="_blank">dramamezzo@gmail.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">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">
<div>
<div class="h5">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></div></div>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div>
<div class="h5">
<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></div></div><span class="HOEnZb"><font color="#888888">--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></font></span></blockquote></div><br>
<br>--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br>