I'm trying to make what I think is a very simple fulltext index for a
small library catalog, viz:
create table library (
id INTEGER UNSIGNED PRIMARY KEY NOT NULL,
callnumber VARCHAR(8) NOT NULL,
lastname TINYTEXT,
firstname TINYTEXT,
middlename TINYTEXT,
title TINYTEXT NOT NULL,
subtitle TINYTEXT,
comments TINYTEXT,
publisher TINYTEXT,
year VARCHAR(6) NOT NULL,
media VARCHAR(20),
FULLTEXT(lastname,firstname,title,subtitle,comments,publisher)
);
I load a few hundred records in and then try to search.
mysql> select * from library where match(title,subtitle) against ('history');
ERROR 1191: Can't find FULLTEXT index matching the column list
What am I doing wrong? Does it dislike tinytext?
Regards,
John Levine, [EMAIL PROTECTED], Primary Perpetrator of "The Internet for Dummies",
Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner
"I dropped the toothpaste", said Tom, crestfallenly.
---------------------------------------------------------------------
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
