Hi,
Sorry for the subject - I just do not know for what to search of what to
ask - I actually do not know where is exactly my problem :-(
I have a database containing thousands of HTML pages ("topics"). There
is a fulltext index for these topics. First there is a table containing
all single wo
On 23 May 2009, at 7:30pm, Lukas Haase wrote:
> SELECT topic_fulltext.topicID
> FROM fulltext
> JOIN topic_fulltext ON topic_fulltext.fulltextID = fulltext.fulltextID
> WHERE word LIKE 'Word%';
>
> But now I want to be able to search with more complex queries. For
> example:
>
> * List all topi
"Lukas Haase" wrote in
message news:gv9fcm$5r...@ger.gmane.org
> I have a database containing thousands of HTML pages ("topics"). There
> is a fulltext index for these topics. First there is a table
> containing all single words. Each word is identified by its
> "fulltextID":
You seem to be reinv
Hi,
At first, thank you for your answer!
Simon Slavin schrieb:
> On 23 May 2009, at 7:30pm, Lukas Haase wrote:
>> SELECT topic_fulltext.topicID
>> FROM fulltext
>> JOIN topic_fulltext ON topic_fulltext.fulltextID = fulltext.fulltextID
>> WHERE word LIKE 'Word%';
>>
>> But now I want to be able to
Hi,
Igor Tandetnik schrieb:
> "Lukas Haase" wrote in
> message news:gv9fcm$5r...@ger.gmane.org
>> I have a database containing thousands of HTML pages ("topics"). There
>> is a fulltext index for these topics. First there is a table
>> containing all single words. Each word is identified by its
>
"Lukas Haase" wrote in
message news:gv9fcm$5r...@ger.gmane.org
> I have a database containing thousands of HTML pages ("topics"). There
> is a fulltext index for these topics. First there is a table
> containing all single words. Each word is identified by its
> "fulltextID":
>
> CREATE TABLE full
On Sun, May 24, 2009 at 02:28:36PM +0200, Lukas Haase wrote:
>
> SELECT topic_fulltext.topicID
> FROM fulltext
> JOIN topic_fulltext ON topic_fulltext.fulltextID = fulltext.fulltextID
> WHERE (word LIKE 'Word1%') AND (word LIKE 'Word2%');
Obviously this must be empty because a string can't start
On 24 May 2009, at 1:28pm, Lukas Haase wrote:
> Simon Slavin schrieb:
>> On 23 May 2009, at 7:30pm, Lukas Haase wrote:
>>> SELECT topic_fulltext.topicID
>>> FROM fulltext
>>> JOIN topic_fulltext ON topic_fulltext.fulltextID =
>>> fulltext.fulltextID
>>> WHERE word LIKE 'Word%';
>>
>> WHERE (wor
On 24/05/2009 4:30 AM, Lukas Haase wrote:
> Hi,
>
> Sorry for the subject - I just do not know for what to search of what to
> ask - I actually do not know where is exactly my problem :-(
>
> I have a database containing thousands of HTML pages ("topics"). There
> is a fulltext index for these
Igor Tandetnik schrieb:
> "Lukas Haase" wrote in
> message news:gv9fcm$5r...@ger.gmane.org
>> I have a database containing thousands of HTML pages ("topics"). There
>> is a fulltext index for these topics. First there is a table
>> containing all single words. Each word is identified by its
>> "fu
"Lukas Haase" wrote in
message news:gve1lh$30...@ger.gmane.org
>> SELECT topic_fulltext.topicID FROM topic_fulltext
>> where exists (select 1 from fulltext
>> WHERE topic_fulltext.fulltextID = fulltext.fulltextID and word
>> LIKE 'word1%')
>> and exists (select 1 from fulltext
>> WHERE top
11 matches
Mail list logo