Hello
Recently we have installed mysql ver 4.0.1(from
binaries).We loaded about 1.6 million records in a table.
One of the fields 'ti' is text field. We created fulltext
index on this field.
on giving following :-
1. select ti from p8387 where match ti against ('computer');
1701 rows were returned.
2. select ti from p8387 where match ti against
('processor');
5608 rows were returned.
3. select ti from p8387 where match ti against
('+computer +processor');
it still returns 5608 rows.
when we gave the following :
4. select ti from p8387 where match ti against
('computer') and match ti against ('processor')
only 31 rows were returned
Can anyone tell me what is the problem with statement no. 3
does mysql 4.0.1 still not support this type of fulltext
search.
Pl. help
Kind Regards
P Tejpal
---------------------------------------------------------------------
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
