Backend for autosuggest for fulltext search?

I'd use mysql's MATCH() AGAINST() (dev.mysql.com/doc/refman/5.5/en/fulltext...), eg.

I'd use mysql's MATCH() AGAINST() (dev.mysql.com/doc/refman/5.5/en/fulltext...), eg: SELECT * FROM table WHERE MATCH(column) AGAINST('search') ORDER BY MATCH(column) AGAINST('search') Another advantage is that you could further tweak the importance of words being searched for (if neccessary), like: MATCH(column) AGAINST('>important.

Good solution for fulltext search, but With this solution I get the whole entry back. I want to complete single words for the autosuggest. How do I get well matching words from the same entrys?

– xerxes Nov 16 at 13:07.

I think, the idea no 1 is the best. By the way, dont't forget to eliminate stopwords from autosuggest (an, the, by, ...).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.