Re: Creating an INDEX on multiple tables?
| From: | Ron Piggott | Date: | Fri, 22 Oct 2010 10:00: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-47416@lists.php.net to get a copy of this message | ||
I have moved the GROUP BY outside now Chris.
In the queries that make up the UNION ALL (such as below) is there a way to only SELECT matches that are 70% or greater based on the users input? Right now each and every listing is a search result.
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_activity.activity )
AGAINST
('$search')
AND ministry_profiles_activity.live =1