Здравствуйте, люди!!! У меня вопрос...
Читал мануал про фултекст, там пример есть, типа:
mysql> CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT (title,body)
);
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO articles VALUES
-> (NULL,'MySQL Tutorial', 'DBMS stands for DataBase ...'),
-> (NULL,'How To Use MySQL Efficiently', 'After you went through a ...'),
-> (NULL,'Optimising MySQL','In this tutorial we will show ...'),
-> (NULL,'1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
-> (NULL,'MySQL vs. YourSQL', 'In the following database comparison ...'),
-> (NULL,'MySQL Security', 'When configured properly, MySQL ...');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0

mysql> SELECT * FROM articles
WHERE MATCH (title,body) AGAINST ('database');
+----+-------------------+------------------------------------------+
| id | title | body |
+----+-------------------+------------------------------------------+
| 5 | MySQL vs. YourSQL | In the following database comparison ... |
| 1 | MySQL Tutorial | DBMS stands for DataBase ... |
+----+-------------------+------------------------------------------+
2 rows in set (0.00 sec)


проблема вот в чём... как так может быть???
создаю таблицу:
create table ind (id int not null auto_increment, zap smallint(1) DEFAULT 1, url varchar(40), nazv varchar(250), d_ind DATE, pop double(8,5) DEFAULT 0, tit double(8,5) DEFAULT 0, ob double(6,5) DEFAULT 1, atit double(8,5) DEFAULT 0, des double(8,5) DEFAULT 0, kw double(8,5) DEFAULT 0, n_rubr varchar(70), opis TEXT, inde TEXT, FULLTEXT (url, nazv, opis, inde), primary key (id))
далее запрос на поиск:
SELECT url, nazv from ind where MATCH(url,nazv,inde) AGAINST('sddfsgdfg')

и Ошибка!!! типа:
Can't find FULLTEXT index matching the column list

как так???

работает