[RESOLVED] What's wrong with this Search Query

[sandthipe]

SELECT title FROM blogs INNER JOIN user_info ON blogs.user_id=user_info.user_id WHERE MATCH (blogs.title,blogs.body) AGAINST ('edited') LIMIT 5

mysql throws no errors, yet returns no results. The search term 'edited' is in the body field of the fulltext index (title,body).

??
Thanks. -Chris

[Roger_Ramjet]

If you are sure that you should get a match then the only possible thing is the inner join: are you sure there is anything in user_info. Test it by taking out the joined table.

[sandthipe]

Thanks Roger. Your idea jogged my thinking. It seems I read somewhere that MySQL by default doesn't return any results if the search term exists in half of the total records. Well, the buzzwords I was testing did exist in half of the records, since I only had 2 records. I just had to add an extra record and the search query worked fine... Live and learn.

Thanks again