Re: Creating an INDEX on multiple tables?
| From: | Chris | Date: | Sun, 24 Oct 2010 22:21:28 +0000 |
| Subject: | Re: Creating an INDEX on multiple tables? | ||
| References: | 1 2 3 4 5 6 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47435@lists.php.net to get a copy of this message | ||
On 22/10/10 21:00, Ron Piggott wrote:
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.http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html has info about doing that sort of thing. -- Postgresql & php tutorials http://www.designmagick.com/