Hmm, the words table is just a table with an id field and a word field, the
word field only contains one word in it and then the id field is that words
id. There is only one word per row.
The searchwords table is a long list of keywords that relate to that field,
i.e. it contains the pdf id, the words, id and it's ranking. They row
duplication problem is occuring when a pdf has both the words that the query
is searching for. Does that make sense?
Thanks
Scott.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On
Behalf Of Carl Troein
Sent: Tuesday, 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 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 that contain 'award' or 'section').
> AND (words.word LIKE '%award%')
> The only problem is, it is still returning the same rows. As in, returning
> rows that are exactly the same?
Well, do you have any rows that contain 'award' but not
'section' and that match the other criteria? Could it
be that you're confusing OR with some other operator,
like XOR or AND NOT?
//C
--
Carl Troein - Cmrdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned proud of it too.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
