SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Sep 2003
    Location
    sydney, Australia
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post How to do full text search in innodb table??

    Problem: how to do full text search in innodb table?

    MySQL has feature of full text search... that's great.

    http://www.mysql.com/doc/en/Fulltext_Search.html

    But the problem is it only works in MyISAM table. What about for innoDB? is there a workaround to this?

    I mean, surely most people use innodb for large-scale databases?

    Or it simply doesn't work at innodb table at all? Hence we have no choice but to use 'like %keyword%'?

    any inputs will be appreciated...

  2. #2
    SitePoint Guru toasti's Avatar
    Join Date
    Feb 2004
    Location
    Grahamstown
    Posts
    634
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you might find that using 'like %keyword% would actually work better than using the MySQL full-text search, cause it is actually quite limited (for starters, it only searches for words longer 3 letters (and you would be amazed how many good keywords are actually less than three letters))

    as far as i know you can't use it in INNODB.

  3. #3
    SitePoint Guru toasti's Avatar
    Join Date
    Feb 2004
    Location
    Grahamstown
    Posts
    634
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    my bad:

    The minimum length of words to be indexed is defined by the MySQL variable ft_min_word_len. See section 4.5.7.4 SHOW VARIABLES. Change it to the value you prefer, and rebuild your FULLTEXT indexes. (This variable is only available from MySQL version 4.0.)

    (form the MySQL manual)


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •