<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">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>
<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:30 PM, Kamal Palei wrote:<br>
</div>
<blockquote
cite="mid:CALO8XuU0ouW_NH9J83-VRRrpJkQASYMGEhVd8iGtb0J8jbC4ig@mail.gmail.com"
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 class="h5">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 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 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 class="HOEnZb"><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 class="mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</body>
</html>