rod_description` (`prod_description`)
) TYPE=MyISAM AUTO_INCREMENT=3367 ;
When I tried this:
SELECT * FROM products
WHERE match (prod_name) against ('+red +shirt');
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_descrip
AM AUTO_INCREMENT=3367 ;
When I tried this:
SELECT * FROM products
WHERE match (prod_name) against ('+red +shirt');
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got thi
On 5/11/2006 9:17 AM Fan, Wellington wrote:
Damn, I really didn't mean to use that subject line; Sorry all!
Nor should you reply to a message when starting a new thread. It screws
up the threading whether or not you change the subject. Please start
all new threads with a new message.
Tha
>>> PRIMARY KEY (`prod_id`),
>>>> UNIQUE KEY `prod_no` (`prod_no`),
>>>> KEY `products_index1` (`prod_status`),
>>>> KEY `products_index2` (`prod_start_date`,`prod_end_date`),
>>>> KEY `on_sale` (`on_sale`),
>>>> FULLTEX
7;);
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I doing wrong?
You need a single FULL
Dude! You just confused me with YOUR QUESTION under MY SUBJECT LINE
:) :) :)
You have to change a Subject and send it again. Or we will not know to
whom is sent.
:)
-afan
> Hello all,
>
> I just inherited an application that has 2 tables under consideration,
> "events" and "attribute_master".
Damn, I really didn't mean to use that subject line; Sorry all!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello all,
I just inherited an application that has 2 tables under consideration, "events"
and "attribute_master". They are linked on (events.eventID =
attribute_master.id AND attribute_master.tableis = 'events'). In other words,
attribute_master.id is kinda like a foreign key to events.eventID
AUTO_INCREMENT=3367 ;
>>
>> When I tried this:
>> SELECT * FROM products
>> WHERE match (prod_name) against ('+red +shirt');
>> I'll get some results.
>> But, when I tried this:
>> SELECT * FROM products
>> WHERE match (pr
ch (prod_name) against ('+red +shirt');
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the column list
What am I
FROM products
WHERE match (prod_name) against ('+red +shirt');
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLT
ch (prod_name) against ('+red +shirt');
I'll get some results.
But, when I tried this:
SELECT * FROM products
WHERE match (prod_name, prod_description) against ('+red +shirt');
I got this error message:
#1191 - Can't find FULLTEXT index matching the
Mirza <[EMAIL PROTECTED]> wrote:
>
> I have error 1191 "can't find fulltext index matching the column list",
> but I am certain that all columns in the list are present in my Fulltext
> index. Does anybody else had this problem? I am using 4.1.0.
>
Show yo
If you do a fulltext search on multiple columns at once, there must be a
combined fulltext index on this exact set of columns. Just having an index
on them individually will not work.
On Wed, 3 Dec 2003, Mirza wrote:
> Hi,
>
> I have error 1191 "can't find fulltext index
Hi,
I have error 1191 "can't find fulltext index matching the column list",
but I am certain that all columns in the list are present in my Fulltext
index. Does anybody else had this problem? I am using 4.1.0.
thanks,
Mirza
--
MySQL General Mailing List
For list
15 matches
Mail list logo
