Shawn-
Works like a champ! Thanks so much. If your ever in the Silicon
Valley area drop me a line, and I will be happy to pick up lunch or
cocktails.
It's great that you are so active on this list and are helping so many
folks on here (myself included).
-Dale
On Fri, 25 Feb 2005 10:06:36 -050
(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 slow (28 seconds).
>
> SELECT *,MATCH(title, descr_part) AGAINST ("Project Manager" IN
> BOOLEAN MODE) AS score
> F
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
