match against with another clause

#1

I have a full text table that I wish to search by matches and by date.
Specifically my sql looks like this:

SELECT url,title,link_date,headings,MATCH (title,content) AGAINST (?) AS
score FROM my_table WHERE MATCH (title,content) AGAINST(?) AND link_date

Quote:

= ? AND link_date <= ?'

This does not appear to work. How do I filter full text matches?

Jeff

#2

On 25-12-2011 15:09, j wrote:

Quote:

I have a full text table that I wish to search by matches and by date.
Specifically my sql looks like this:

SELECT url,title,link_date,headings,MATCH (title,content) AGAINST (?) AS
score FROM my_table WHERE MATCH (title,content) AGAINST(?) AND link_date
= ? AND link_date <= ?'

This does not appear to work. How do I filter full text matches?

Jeff

do this:
mysql> show variables like 'ft%';
+--------------------------+----------------+

Quote:

5 rows in set (0.00 sec)

and find out what the value mean that get returned.
more info:
http://dev.mysql.com/doc/refman/5.0/...ne-tuning.html

--
Luuk

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

match against with another clause

comp.databases.mysql comp.databases.mysql

match against with another clause - 12-25-2011 , 08:09 AM

Re: match against with another clause - 12-26-2011 , 03:56 AM