Re: Creating an INDEX on multiple tables?
| From: | Ron Piggott | Date: | Fri, 22 Oct 2010 02:31:11 +0000 |
| Subject: | Re: Creating an INDEX on multiple tables? | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47412@lists.php.net to get a copy of this message | ||
Bastien (and others) I am still having one problem with this query I don't know how to resolve:
When I add the category column:
ministry_categories.category as part of the MATCH () I receive the error:
"Incorrect arguments to MATCH"
I create the LEFT OUTER JOINs to allow additional columns to be part of the MATCH. I have made this "category" column a FULLTEXT index in the ministry_categories table. The query that produces the error is below.
Is there a way this will work?
Ron
===
SELECT ministry_profiles.reference, ministry_profiles.organization FROM
(
(
( ministry_profiles LEFT OUTER JOIN ministry_profiles_listing_details ON ministry_profiles.reference = ministry_profiles_listing_details.ministry_profile_reference )
LEFT OUTER JOIN ministry_profiles_activity ON ministry_profiles.reference = ministry_profiles_activity.ministry_profiles_reference )
LEFT OUTER JOIN ministry_profile_categories ON ministry_profiles.reference = ministry_profile_categories.ministry_profiles_reference )
LEFT OUTER JOIN ministry_categories ON ministry_profile_categories.ministry_categories_reference = ministry_categories.reference
WHERE
MATCH( ministry_profiles.organization, ministry_profiles.address_line_1, ministry_profiles.address_line_2, ministry_profiles.city, ministry_profiles.province_state, ministry_profiles.postal_zip_code, ministry_profiles.country, ministry_profiles.telephone, ministry_profiles.toll_free, ministry_profiles.fax, ministry_profiles.email, ministry_profiles.website, ministry_categories.category )
AGAINST
('$search')
AND
ministry_profiles.live =1
GROUP BY ministry_profiles.reference