SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Guru
    Join Date
    Sep 2004
    Location
    Provo, UT
    Posts
    858
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Using keyword = 'believe' instead of match(keyword) against('believe')

    The first query produces many rows. The second query doesn't produce any. If I change the keyword to lemon instead of believe, then both queries produce results. Any ideas on this one?

    select * from searches where keyword = 'believe' order by sID;


    select * from searches where MATCH(keyword) AGAINST('believe');


    Thanks!
    Convert your dollars into silver coins. www.convert2silver.com

  2. #2
    Hosting Team Leader silver trophybronze trophy
    cpradio's Avatar
    Join Date
    Jun 2002
    Location
    Ohio
    Posts
    5,169
    Mentioned
    153 Post(s)
    Tagged
    0 Thread(s)
    Does keyword have FULLTEXT enabled?

  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,276
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    perhaps 'believe' occurs in more than half the rows

    remember, fulltext searching is supposed to work best on large datasets with sparse matches, and in particular, it's optimized for more complex searches, e.g. '+apple +(>turnover <strudel)'
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"


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
  •