MySQL do you have?
Brian McCain
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 8:33 AM
Subject: Fulltext Search Problem
>
> Hi,
>
> Why does this not work?
>
> SELECT * FROM News WHERE category='sport
al Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 18, 2003 8:33 AM
Subject: Fulltext Search Problem
>
> Hi,
>
> Why does this not work?
>
> SELECT * FROM News WHERE category='sport' AND MATCH
> (subcategory,headline,s
Hi,
Why does this not work?
SELECT * FROM News WHERE category='sport' AND MATCH
(subcategory,headline,summary) AGAINST ('madrid') LIMIT 1,25
If i remove the "category='sport' AND" from the WHERE clause it works - yet all
documents in the db currently have category='sport'. Is it not possible t
