Hello,
CREATE TABLE IF NOT EXISTS test (
id mediumint(6) unsigned NOT NULL DEFAULT '0' ,
txt text ,
PRIMARY KEY (id)
);
#insert..... 40000 rows
ALTER TABLE test ADD FULLTEXT findind (txt);
select * from test where match(txt) against('+sony -playstation' in boolean
mode)
(25 rows returned)
select * from test where match(txt) against('+sony -playstatio* ' in boolean
mode)
(0 rows returned)
select * from test where match(txt) against('-playstatio* +sony ' in boolean
mode)
(25 rows returned)
Above results from mysql-4.0.2, cloned today (2002-03-21)
With best regards and wishes,
Alexander
--------------
Uptime: 32 min 45 sec
Threads: 3 Questions: 43493 Slow queries: 0 Opens: 29 Flush tables: 1
Open tables: 1 Queries per second avg: 22.134
--------------
---------------------------------------------------------------------
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
