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 Link to comment https://forums.phpfreaks.com/topic/155431-fulltext-search/ Share on other sites More sharing options...
fenway Posted April 24, 2009 Share Posted April 24, 2009 What's wrong the mysql refman? Link to comment https://forums.phpfreaks.com/topic/155431-fulltext-search/#findComment-818283 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 Link to comment https://forums.phpfreaks.com/topic/155431-fulltext-search/#findComment-818305 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 Link to comment https://forums.phpfreaks.com/topic/155431-fulltext-search/#findComment-818335 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 :/ Link to comment https://forums.phpfreaks.com/topic/155431-fulltext-search/#findComment-818372 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. Link to comment https://forums.phpfreaks.com/topic/155431-fulltext-search/#findComment-818375 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.