rewriting this query to remove IN
| From: | Scott Mebberson | Date: | Mon, 12 Feb 2001 00:15:20 +0000 |
| Subject: | rewriting this query to remove IN | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-6537@lists.php.net to get a copy of this message | ||
Hi Guys,
I understand that as of version 3.24, MySQL will support subselects. But
untill then (because 3.23 is the latest stable release) I need to convert
this SQL satement into something that can be used with v3.2? - the version
just before the latest release.
$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";
Does anybody have any ideas, thanks for this guys. Any help is much
appreciated.
Scott Mebberson