[SOLVED] Can't find FULLTEXT index matching the column list...

[ToonMariner]

I have the following query...

 

SELECT

`media`.* ,

`user`.`username`,

DATEDIFF(NOW(), `media`.`added`) AS `period`

FROM

`media` ,

`user`

WHERE

`media`.`flag` != 'm'

AND

`user`.`user_id` = `media`.`user_id`

AND

(

  MATCH ( `media`.`search`, `media`.`title` )

  AGAINST ('radio')

OR

  `title` LIKE '%radio%'

)

 

I have `media`is a MyISAM table and i have placed a fulltext index on the search amd title fields.

 

Could anyone be so kind as to point out what I am doing wrong???

 

Thanks people...

[ToonMariner]

Its OK I missed 'IN BOOLEAN MODE' from the match clause....