Re: [PHP-DB] rewriting this query to remove IN

2001-02-15 Thread Stas Trefilov
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 DE

Re: [PHP-DB] rewriting this query to remove IN

2001-02-12 Thread Bob Hall
>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(s

[PHP-DB] rewriting this query to remove IN

2001-02-11 Thread Scott Mebberson
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_ta