CODEWITHSUNDEEP
phpmysqlsql
Tarun Baraiya
Tarun Baraiya

Reputation: 504

MATCH (somefeald) AGAINST ('+".$_GET['search']."' IN BOOLEAN MODE) not work

Why does this SQL query return a blank result?

select
 webs.title,webs.disc,webs.logo,webs.id
from 
 webs
 JOIN rel ON rel.webid=webs.id
 JOIN catagory on catagory.id=rel.catid 
where 
  webs.app!=0 
  AND MATCH (webs.title,webs.city,webs.state,webs.url,catagory.catname) AGAINST ('+".$_GET['search']."' IN BOOLEAN MODE)

This is a query for multiples searches in multiple tables and fields. I also want to order the result by the best matching word.

Upvotes: 0

Views: 314

Answers (1)

Deepak Kumar
Deepak Kumar

Reputation: 92

If you want to use "MATCH() ... AGAINST", first create fulltext index on the field which you want in match.

Upvotes: 2

Related Questions