Help resolved MATCH () AGAINST syntax
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
Subject
Views
Written By
Posted
Help resolved MATCH () AGAINST syntax
10307
January 29, 2009 11:08AM
3932
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.