<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Yup, MyISAM is your only option and you
can do just that one table.<br>
<br>
For misspelled words, you need a different search solution like
SOLR. <br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://www.intoxination.net">http://www.intoxination.net</a>
<a class="moz-txt-link-freetext" href="http://www.hollyit.net">http://www.hollyit.net</a></pre>
On 8/27/2012 8:43 PM, Kamal Palei wrote:<br>
</div>
<blockquote
cite="mid:CALO8XuW9W+LMGbKAH03NoXZavGsh=sqNFF7f8LWUakQcmXLtdQ@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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 moz-do-not-send="true" href="http://www.intoxination.net/" target="_blank">http://www.intoxination.net</a>
<a moz-do-not-send="true" 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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
href="http://lists.drupal.org/"
target="_blank">http://lists.drupal.org/</a>
]<br>
</font></span></blockquote>
</div>
<br>
<br>
--<br>
[ Drupal support list | <a moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<br>
</blockquote>
</div>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</body>
</html>