Hi!
On Apr 09, Mike<mickalo>Blezien wrote:
> On Mon, 9 Apr 2001 23:16:21 +0200, Sergei Golubchik <[EMAIL PROTECTED]> wrote:
>
> Then how come I keep getting these results when setting a test table. Am I
> missing something here??
>
> Create the table:
> DROP TABLE IF EXISTS bus_search;
> CREATE TABLE bus_search (
> bus_id int(8),
> title varchar(200),
> keywords TEXT,
> cat_prefix char(2),
> FULLTEXT (title,keywords)
> );
>
>
> Insert Test Data:
> INSERT INTO bus_search (bus_id,tite,keywords,cat_prefix)
> VALUES('9','Dealersecrets, Inc.','Secrets to the Best Car Deals negotiating
> prices book with tips for buying','VE');
>
> Run queries:
>
> QUERY1:
> SELECT title FROM bus_search
> WHERE MATCH(title,keywords) AGAINST('car deals')
>
> 0 rows returned
> ------
> QUERY2:
> EXPLAIN SELECT title FROM bus_search
> WHERE MATCH(title,keywords) AGAINST('car deals')
> Comment
> Impossible WHERE noticed after reading const tables
>
Add more rows, and read in the manual, why FULLTEXT doesn't work correctly
with very few rows.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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