06:36 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> (response NOT top-posted. see below...)
>
> Dale Roddy <[EMAIL PROTECTED]> wrote on 02/24/2005 05:40:22 PM:
>
>
> > I am new to MySql. I have a query with a subselect that is running
> > very s
I am new to MySql. I have a query with a subselect that is running
very slow (28 seconds).
SELECT *,MATCH(title, descr_part) AGAINST ("Project Manager" IN
BOOLEAN MODE) AS score
FROM listings
WHERE MATCH(title, descr_part) AGAINST ("Project Manager" IN BOOLEAN MODE )
and zip in
(SELECT z
