HI all
SOme questions ..
1- the index mode for FULLTEXT search use a stop word for emtpy the bad words
in index structure ? or only use ft_stop_word in query mode ?
2- My method for retrive de aproximate results of a query and the same query
ordery by weight is follow :
"Select count(id) as total_results from articles where match(Title,Content)
agianst(" string " IN BOOLEAN MODE);
Select id,Title,match(Title,Content) against("string") as th from articles
where match(Title,Content) against(" sgring" IN BOOLEAN MODE) order by th
limit init,offset;"
Exists one similiar select for split this selects ?
Thks for all, and sorry for my english
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php