I'm getting into (finally) mysql and miva and I'm trying to figure out what the limitations are. For example, I'm trying to use the MATCH word while doing a text search and get
MvOPENVIEW: Syntax Error: 'MATCH' unexpected.
Is this because MATCH is not supported or is it because I'm not using it right?
For example, on stackoverflow I found an example like this:
SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')
so I try to emulate it like this (also tried putting g.sterm in the ? spot):
<MvOPENVIEW NAME = "db"
VIEW = "results"
QUERY = "{ '
SELECT id
FROM sometable
WHERE
MATCH (title) AGAINST(?) '}"
FIELDS = "g.sterm">
Thanks in advance for any tips.
MvOPENVIEW: Syntax Error: 'MATCH' unexpected.
Is this because MATCH is not supported or is it because I'm not using it right?
For example, on stackoverflow I found an example like this:
SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')
so I try to emulate it like this (also tried putting g.sterm in the ? spot):
<MvOPENVIEW NAME = "db"
VIEW = "results"
QUERY = "{ '
SELECT id
FROM sometable
WHERE
MATCH (title) AGAINST(?) '}"
FIELDS = "g.sterm">
Thanks in advance for any tips.
Comment