Re: Creating an INDEX on multiple tables?
| From: | Chris | Date: | Fri, 22 Oct 2010 03:02:53 +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-47413@lists.php.net to get a copy of this message | ||
On 22/10/10 13:31, Ron Piggott wrote:
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:You can't do a full text match across tables. One of the previous suggestions was to union the results, you end up with something like select field from t1 where match(field1, field2) against ('search term') union all select field from t2 where match(field3, field4) against ('search term') etc though I don't know if that would work (I've never tried it). -- Postgresql & php tutorials http://www.designmagick.com/ministry_categories.categoryas 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.