SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Jun 2006
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    FullText Question

    I have a table with fulltext indexing on three columns. In one of these columns has the value: Testing

    When I use the query below I get no results:
    Code MySQL:
    SELECT id, MATCH(col1, col2, col3) AGAINST('Test') AS score FROM mytable WHERE MATCH(col1, col2, col3) AGAINST('Test') ORDER BY score DESC

    But nothing gets returned. But when I use the search term: Testing instead of just test, the row I am looking for is returned.

    I know i can use LIKE to do this, but is there a way within the fulltext searching to return more than just exact matches?

    Any ideas would be much appreciated, thanks in advance.

  2. #2
    SitePoint Zealot
    Join Date
    Jun 2006
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i've found that you cand use this for prefixes,

    AGAINST('searchstring*' IN BOOLEAN MODE)

    but why doesn't this work

    AGAINST('*searchstring*' IN BOOLEAN MODE)


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
  •