MySQL Forums
Forum List  »  Full-Text Search

Help resolved MATCH () AGAINST syntax
Posted by: Patrick Rooney
Date: January 29, 2009 11:08AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Help resolved MATCH () AGAINST syntax
10251
January 29, 2009 11:08AM
3894
February 23, 2009 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.