This is a follow-up to a MySQL keyword text search question I had answer a few days ago.
I have table 'main' which has two INT columns 'maincat' and 'subcat' which hold an index number from to other tables maincat and subcat. These table each hold descriptive names ('name') for each of the main categories and sub categories. I have no problem using MATCH to search the various fields of 'main' using an INDEX. The problem is I want to create a search across the related 'name' fields of the other two tables. Here is what I have so far: select main.id, description, maincat.name, subcat.name from main LEFT JOIN clients ON forsale.clientid=clients.id WHERE MATCH (description) AGAINST ('keywords') This works but I can only MATCH in the columns of 'main'. Now my first thought was to try this: select main.id, description, maincat.name, subcat.name from main LEFT JOIN clients ON forsale.clientid=clients.id WHERE MATCH (description, maincat.name, subcat.name) AGAINST ('keywords') Which results in an error. Can anyone tell me if I can do this using MATCH? Thanks, Dan --------------------------------------------------------------------- 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