hi, this was working, i did something, now it's not (no results are being returned). any help would be appreciated. i know it's vague but i don't know where to look.
#
#an example sql query:
#
SELECT id, product, description,
match (product,description) against (' sandra diamond ') as relevance
FROM Hhood.inventory
WHERE
match (product,description) against ('sandra')>0 AND match (product,description) against ('diamond')>0
HAVING relevance>0
ORDER BY relevance DESC
#
# Table structure for table `inventory`
#
CREATE TABLE inventory (
product varchar(255) NOT NULL default '',
quantity int(6) NOT NULL default '1',
id int(6) NOT NULL auto_increment,
description text,
price float(10,2) NOT NULL default '0.00',
category varchar(255) NOT NULL default '1',
bin_data longblob,
filename varchar(50) default NULL,
filesize varchar(50) default NULL,
filetype varchar(50) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
FULLTEXT KEY product (product,description)
) TYPE=MyISAM;
#
#Indexes:
#
Keyname /Unique /Fulltext /Field
PRIMARY /Yes /No /id
id /Yes /No /id
product -1- /No /Yes /product
product -2- /No /Yes /description 1
again, any help would be appreciated.
-nick
#
#an example sql query:
#
SELECT id, product, description,
match (product,description) against (' sandra diamond ') as relevance
FROM Hhood.inventory
WHERE
match (product,description) against ('sandra')>0 AND match (product,description) against ('diamond')>0
HAVING relevance>0
ORDER BY relevance DESC
#
# Table structure for table `inventory`
#
CREATE TABLE inventory (
product varchar(255) NOT NULL default '',
quantity int(6) NOT NULL default '1',
id int(6) NOT NULL auto_increment,
description text,
price float(10,2) NOT NULL default '0.00',
category varchar(255) NOT NULL default '1',
bin_data longblob,
filename varchar(50) default NULL,
filesize varchar(50) default NULL,
filetype varchar(50) default NULL,
PRIMARY KEY (id),
UNIQUE KEY id (id),
FULLTEXT KEY product (product,description)
) TYPE=MyISAM;
#
#Indexes:
#
Keyname /Unique /Fulltext /Field
PRIMARY /Yes /No /id
id /Yes /No /id
product -1- /No /Yes /product
product -2- /No /Yes /description 1
again, any help would be appreciated.
-nick