f1r3fl3x Posted April 23, 2009 Share Posted April 23, 2009 I looked at some examples in the net, but here isn't a good example on how to create an accurate fulltext search. Will anyone show me how to do it. I wrote this code SELECT * FROM lyrics WHERE MATCH (search_key) AGAINST ('"+search* +words*"' IN BOOLEAN MODE) LIMIT 10 My MySQL version is 5.0.67-community-log. :-X Quote Link to comment Share on other sites More sharing options...
fenway Posted April 24, 2009 Share Posted April 24, 2009 What's wrong the mysql refman? Quote Link to comment Share on other sites More sharing options...
f1r3fl3x Posted April 24, 2009 Author Share Posted April 24, 2009 Nothing's wrong, it works, but it's not accurate enough Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted April 24, 2009 Share Posted April 24, 2009 Then don't use mysql for searching text. It's slow and the results aren't great. Implement a search using a fulltext search index using the likes of Sphinx or Lucene. Far better and much, much faster. http://sphinxsearch.com/docs/manual-0.9.9.html http://framework.zend.com/manual/en/zend.search.lucene.html Quote Link to comment Share on other sites More sharing options...
f1r3fl3x Posted April 24, 2009 Author Share Posted April 24, 2009 I can't use neither @neil.johnson becouse the website is not on my computer it's on a host :/ Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted April 24, 2009 Share Posted April 24, 2009 You can upload the Zend Framework anywhere. It may already be available on your hosting package. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.