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
>>Hi!
>>
>>On Apr 09, Mike<mickalo>Blezien wrote:
>>> I posted a couple problems regarding the use of the FULLTEXT indexing and a
>>> search query problem, but never got any responses. So maybe some one may shed
>>> some lite on setting up a table with the FULLTEXT index.
>>>
>>> I've read thru the MySQL docs on this and it's not real clear. When setting up a
>>> table, when an utilizing a FULLTEXT index. When creating the table, can it only
>>> have to columns or can the table have more then two columns:
>>>
>>> CREATE TABLE search
>>> ( id int(8),
>>> title varchar(200),
>>> keywords TEXT,
>>> category char(2)
>>> FULLTEXT (title,keywords)
>>> )
>>>
>>> Is this correct or can you only have two columns when using the FULLTEXT
>>> Indexing??
>>
>>The above is correct.
>>
>>By the way, you was able to find it yourself - thus saving
>>your time - by trying to execute the SQL statement above.
>>
>>Regards,
>>Sergei
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
