Full Text Not Returning Results....

MrLister

I made full text of (artist,title)

min word len is at 3

i put this query in "SELECT * FROM table WHERE MATCH (artist,title) AGAINST ('$search') LIMIT 100"

If I type in an exact title name i don't get anything back such as.. $search = "here without you"; would return nothing but if i do "select * fro mtable where title like '$search'" it would return back the row.

this is one example of many that it does. like even if i do a search for "here" or "without" or a combination it just doesn't return it. any ideas? (i did repair table but that didn't help)

LordShryku

Match only returns results if the match is in less than half of the table. Take a look at the MySQL manual for FULLTEXT, and it will explain it for you

MrLister

The table has 210,000 rows or so

LordShryku

Well...you did setup the fulltext index, right?

MrLister

Yea both are on full text index. Artists it has no problem doing a perfect match but if i put the title alone as the perfect match it doesn't return anything.