I'm attempting to write a query as follows: ($query^10) OR (NOT ($query)) which effectively would return everything, but if it matches the first query it will get a higher score and thus be sorted first in the result set. Unfortunately the results are not coming back as expected. ($query) works by itself and gets X rows (NOT ($query)) works by itself and gets Y rows You would expect ($query) OR (NOT ($query)) to return X+Y rows but it is only returning X rows. What am I doing wrong?
- Query not working as expected Matt Schraeder
- RE: Query not working as e... Harsch, Timothy J. (ARC-SC)[PEROT SYSTEMS]
- Re: Query not working as e... Mark Miller
- RE: Query not working as e... Matt Schraeder
- Re: Query not working as e... Matt Schraeder