RE: My SELECT is still returning the same rows

2001-09-25 Thread Scott Mebberson
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

Re: My SELECT is still returning the same rows

2001-09-25 Thread Carl Troein
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

My SELECT is still returning the same rows

2001-09-24 Thread Scott Mebberson
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