If I am using the MATCH function to search within a field with a
FULLTEXT index, can I add additional qualifiers to refine that
search? For example:
SELECT *, MATCH (Description) AGAINST ('unique') AS score FROM
Tags.web WHERE MATCH (Description) AGAINST ('unique') AND
type='Record'
Will this work to search the field defined with the FULLTEXT index,
but also be constrained by the AND operator to only includes certain
records (in this case records with the text 'Record' in the field
type).
Would this have to be a sub-select? (though I know MySQL is not able
to do sub-selects in a strict sense)
--
Michael
__
||| Michael Collins |||
||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED]
||| Seattle, WA, USA ||| http://www.lassodev.com
database,sql,query,table
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
