Help resolved MATCH () AGAINST syntax

[Patrick Rooney]

Hi
Having difficutly getting this to work

SELECT c.*, a.*
FROM contentartist ca, content c , artist a
WHERE ca.contentid = c.contentid
AND ca.artistid = a.artistid
AND MATCH(Title,Description,ArtistName) AGAINST('Bowie')
ORDER BY Title ASC

Trying to search a table of artists and content for a keyword. CONTENTARTIST is the JOIN table.

Getting this message:

SQL query:

SELECT c . * , a . *
FROM contentartist ca, content c, artist a
WHERE ca.contentid = c.contentid
AND ca.artistid = a.artistid
AND MATCH (
Title, Description, ArtistName
)
AGAINST (
'Hosley'
)
ORDER BY Title ASC
LIMIT 0 , 30

MySQL said:

#1210 - Incorrect arguments to MATCH

Thanks in advance for you help

Paddy