<div>HI Jamie Holly </div>
<div>Thanks for information.</div>
<div> </div>
<div>So, probably I should have that particular table as myisam now, later convert it to innodb.</div>
<div> </div>
<div>By the way, how people acheive searching of wrong spelt words (example if I type wrong spelt word in google search field).</div>
<div> </div>
<div>Regards</div>
<div>Kamal</div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Aug 28, 2012 at 6:06 AM, Jamie Holly <span dir="ltr"><<a href="mailto:hovercrafter@earthlink.net" target="_blank">hovercrafter@earthlink.net</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div text="#000000" bgcolor="#FFFFFF">
<div>MySQL's full text support for InnoDB is highly new. You have to be running MySQL 5.6.4+. MySQL 5.6 is still in dev, so unless you are on a dedicated server, VPS or Cloud and want to get really risky with your data, you are going to have to wait. <br>
<span class="HOEnZb"><font color="#888888"><pre cols="72">Jamie Holly
<a href="http://www.intoxination.net/" target="_blank">http://www.intoxination.net</a>
<a href="http://www.hollyit.net/" target="_blank">http://www.hollyit.net</a></pre></font></span>
<div>
<div class="h5">On 8/27/2012 8:30 PM, Kamal Palei wrote:<br></div></div></div>
<div>
<div class="h5">
<blockquote type="cite">
<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>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>
<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><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><br>
<fieldset></fieldset> <br></blockquote><br></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>