Ask a Question related to Macromedia Dynamic HTML, Design and Development.
-
....hooligan #1
MySql, PHP FULLTEXT problem
I have a PHP file that sets up a few tables and when i run the script i get
this error
The used table type doesn't support FULLTEXT indexes
What does it mean?
Heres the code that sets up the table
CREATE TABLE IF NOT EXISTS cms_articles (
article_id int(11) NOT NULL auto_increment,
author_id int(11) NOT NULL default '0',
is_published tinyint(1) NOT NULL default '0',
date_submitted datetime NOT NULL default '0000-00-00 00:00:00',
date_published datetime NOT NULL default '0000-00-00 00:00:00',
title varchar(255) NOT NULL default '',
body mediumtext NOT NULL,
PRIMARY KEY (article_id),
KEY IdxArticle (author_id,date_submitted),
FULLTEXT INDEX IdxText (title,body)
)
Thanks in Advance
....hooligan Guest
-
partial word search with FULLTEXT
MySQL FULLTEXT searches support wildcard suffixes such as: mysql> SELECT * FROM articles WHERE MATCH (title,body) -> AGAINST ('apple*' IN BOOLEAN... -
FULLTEXT mysql query keeps hanging
'm using a MYSQL database for my new google maps site.. I want to enable a search by address and therefore will be using the FULLTEXT feature... -
Tune performance of fulltext search
Hi, I am running MySQL on a well equipped server, 2Xeon, 4G RAM and SCSI-RAID. I got one real big table with 10M rows and fulltext index. Most... -
Top words in Mysql Fulltext indexes
Hi! Is there any way to get the most popular words in the mysql FULLTEXT indexes? Thanks in advance! -
MySQL UNION on 2 Fulltext search queries
++Captain Tripps++: If they are identical, why do you have two tables in the first place? What version are you using? Mysql 3.* doesn't...



Reply With Quote

