Author: gluke
Email: [EMAIL PROTECTED]
Message:
> SELECT url.url, count(*) as c
> FROM url,dict
> WHERE dict.url_id=url.rec_id
> AND dict.word IN ('some','word')
> GROUP BY url.url
> ORDER BY c DESC
>
> which will return all urls with ANY of the search terms in the IN() condition, the
>equivalent of an "OR search term" search. Is it possible to do the
>equivalent of an "AND search terms" search, i.e., ALL the words are found
>in every document? Or is that the same as adding something like WHERE c >=
>(num_of_search_terms)?
No, you can learn the correct way to fetch results on our old-branch PHP frontend
(version 3.1.2.5). You can put it into debug mode and look at the querie it sends to
SQL server. Those queries are rather complex, so i think it is easier to look at them
by yourself.
Reply: <http://www.mnogosearch.org/board/message.php?id=4548>
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
