Hi!
On Mar 21, Lorderon wrote:
> Hi,
>
> I also found that when you use JOIN with full-text, MySQL don't
> automatically sort the results by the coefficient of the full-text... when
> you use list of tables seperated by comma MySQL sorts it correctly...
What does EXPLAIN say in each case ?
Reg
Hi,
"Sergei Golubchik" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi!
>
> On Mar 20, Lorderon wrote:
> > I have 3 tables to join when the last one is a Full-Text table
(ft_table)..
> > I do the next join:
> >
> > SELECT id,title FROM table1 LEFT JOIN table2 USING (id) INNER JOIN
Hi!
On Mar 20, Lorderon wrote:
> I have 3 tables to join when the last one is a Full-Text table (ft_table)..
> I do the next join:
>
> SELECT id,title FROM table1 LEFT JOIN table2 USING (id) INNER JOIN ft_table
> USING (id) WHERE ...
>
> But MySQL selects the primary key (id) to join the ft_tabl
I have 3 tables to join when the last one is a Full-Text table (ft_table)..
I do the next join:
SELECT id,title FROM table1 LEFT JOIN table2 USING (id) INNER JOIN ft_table
USING (id) WHERE ...
But MySQL selects the primary key (id) to join the ft_table, which makes the
query run a lot of time and
