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??
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
