Re: rewriting this query to remove IN
| From: | (Stas Trefilov) | Date: | Wed, 14 Feb 2001 18:07:16 +0000 |
| Subject: | Re: rewriting this query to remove IN | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-6652@lists.php.net to get a copy of this message | ||
Hello, "Scott Mebberson"!
You wrote:
> $search = "SELECT count(search_table.word) as score,
> search_table.qid,page_data.contents
> FROM search_table,page_data
> WHERE page_data.pID = search_table.qid AND
> search_table.word
> IN($querywords)
> GROUP BY search_table.qid
> ORDER BY score DESC";
>
GROUP BY search_table.qid, page_data.contents
--
Piloteers do it on the road