<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>&nbsp;</div>
      <div>So, probably I should have that particular table as myisam
        now, later convert it to innodb.</div>
      <div>&nbsp;</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>&nbsp;</div>
      <div>Regards</div>
      <div>Kamal</div>
      <div><br>
        <br>
        &nbsp;</div>
      <div class="gmail_quote">On Tue, Aug 28, 2012 at 6:06 AM, Jamie
        Holly <span dir="ltr">&lt;<a moz-do-not-send="true"
            href="mailto:hovercrafter@earthlink.net" target="_blank">hovercrafter@earthlink.net</a>&gt;</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>&nbsp;</div>
                  <div>I know with 'like' query&nbsp;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>&nbsp;</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>&nbsp;</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>&nbsp;</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">&lt;<a
                        moz-do-not-send="true"
                        href="mailto:dramamezzo@gmail.com"
                        target="_blank">dramamezzo@gmail.com</a>&gt;</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&nbsp; 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">&lt;<a
                                moz-do-not-send="true"
                                href="mailto:palei.kamal@gmail.com"
                                target="_blank">palei.kamal@gmail.com</a>&gt;</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>&nbsp;</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>&nbsp;</div>
                              <div><b>SELECT * FROM resubmt_skill_ids
                                  WHERE MATCH (name) AGAINST ('java')</b></div>
                              <div>&nbsp;</div>
                              <div>But I get the below error.</div>
                              <div>&nbsp;</div>
                              <div>#1214 - The used table type doesn't
                                support FULLTEXT indexes</div>
                              <div>&nbsp;</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>&nbsp;have
                                not gone completely, but it looks author
                                tells full-text search possible with
                                innodb tables.</div>
                              <div>&nbsp;</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>&nbsp;</div>
                              <div>Best Regards</div>
                              <div>Kamal</div>
                              <div>NECS, Bangalore</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</div>
                              <div>&nbsp;</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>