On Tue, 10 Apr 2001 01:05:47 +0200, Sergei Golubchik <[EMAIL PROTECTED]> wrote:
Ok, I kind of thought that might be it, but wasn't sure.
Thanks for you assistance.
>>> 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.
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
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