Hi Brian,
Sorry, I was mistaken. It does work! The documents in question, were not
category='sport'.
Regards
Martin
"Brian McCain" <[EMAIL PROTECTED]>
18/03/2003 17:23
To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject: Re: Fulltext Search Problem
No, that should work. Do any items in the db have the text 'madrid' in
them?
Does it fail with an error or does it simply not return any results? Are
you
executing it on the command line? If not, are you checking for errors?
What
version of 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' 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
to
mix
> a MATCH with another condition?
>
> Any ideas, or is the only solution to run the first query, store the
results in
> a temp table, and then run a 2nd query.
>
> Regards
> Martin Curmi
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
