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 - Círdan / 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
