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

  • Full... Lorang Jacques
    • ... Lorang Jacques
    • ... Lorang Jacques
      • ... Charlie Harrison
    • ... alec . cawley
    • ... Laurence Aronberg
      • ... Sergei Golubchik
    • ... Pawan Tejpal SA Intellectual Property Ptejpal Knowhow Informatics NIC
      • ... Sergei Golubchik
    • ... Pau Freixes
    • ... Sidar Lopez Cruz
    • ... Heikki Tuuri
      • ... Wynne Crisman
        • ... Heikki Tuuri
    • ... Sidar Lopez Cruz
      • ... Jennifer Goodie
        • ... Jeremy Zawodny
          • ... Brian McCain
            • ... Jeremy Zawodny
            • ... Jayce^

Reply via email to