y, 25 September 2001 3:34 AM
To: [EMAIL PROTECTED]
Subject: Re: My SELECT is still returning the same rows
Scott Mebberson writes:
> AND (words.word LIKE '%award%' OR words.word LIKE '%section%') ## <-
> difference between 1 and 2 word search
What do you mean by t
Scott Mebberson writes:
> AND (words.word LIKE '%award%' OR words.word LIKE '%section%') ## <-
> difference between 1 and 2 word search
What do you mean by that comment? I can't make any real sense
out of it, and it doesn't seem to have much to do with the actual
query (which returns rows
Hi Guys,
The following query that I am using is returning duplicate rows.
For a two word search:
SELECT DISTINCT
pdf.title,
pdf.filename,
searchwords.ranking,
pdf.summary
FROM
pdf,
words,
searchwords
WHERE
words.id = searchwords.wo