Re: Query Confusion!

2008-04-12 Thread Brent Baisley
Is the plus query return more then 50% of the records? If so, MySQL won't return anything since the result set isn't that relevant. Brent Baisley Systems Architect On Apr 11, 2008, at 8:08 AM, Barry wrote: I am confused ( nothing new there), what I thought was a simple search is proving

Re: Query Confusion!

2008-04-12 Thread Barry
There are only 500 records in total of which three are relevant to the 'plus' query. But there is only 1 relevant result from the 'real' query, and that did return a result. Brent Baisley wrote: Is the plus query return more then 50% of the records? If so, MySQL won't return anything