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