Thread: need some input?
View Single Post
  #1  
Old 05-24-2007, 04:22 AM
flux flux is offline
Junior Member
  
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
flux is on a distinguished road
Default need some input?
Hi guys,
Using 5.0.22 version, I found problems with boolean mode in full text search on more then one column. When looking for Ford AND Escort i have as query:

SELECT *, MATCH (Titel,Tekst) AGAINST ('+ford+escort') AS Score FROM artikelen WHERE MATCH (Titel,Tekst) AGAINST ('+ford+escort') ORDER BY Score DESC LIMIT 0,100

But as result pages I get results with only Ford or Escort in it, in stead of Ford AND Escort. Any thoughts of which mistake am I making? Please reply.
Thank you so much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - need some input?
Thread: need some input?
View Single Post
  #1  
Old 05-24-2007, 04:22 AM
flux flux is offline
Junior Member
  
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
flux is on a distinguished road
Default need some input?
Hi guys,
Using 5.0.22 version, I found problems with boolean mode in full text search on more then one column. When looking for Ford AND Escort i have as query:

SELECT *, MATCH (Titel,Tekst) AGAINST ('+ford+escort') AS Score FROM artikelen WHERE MATCH (Titel,Tekst) AGAINST ('+ford+escort') ORDER BY Score DESC LIMIT 0,100

But as result pages I get results with only Ford or Escort in it, in stead of Ford AND Escort. Any thoughts of which mistake am I making? Please reply.
Thank you so much. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote