Hello,
I did the following query against my indexed table:
select * from indexed_table where match(indexed_col)
against ('oracle +sybase +london')
It returned 16 rows of which only 4 rows included all words.
I then did:
select * from indexed_table where match(indexed_col)
against ('+oracle +sybase +london')
It returned 4 rows which is the desired or expected results.
I then did:
select * from indexed_table where match(indexed_col)
against ('+oracle +sybase +london -oracle')
Nothing was returned.
I then went on to do this:
select * from indexed_table where match(indexed_col)
against ('oracle and sybase and london')
This returned over 200 rows rather than the expected 4.
This was done against mySQL v4.0.
Can someone please explain the ambiguities.
Joe B.
*********************************************************************
* Visit http://www.computerstaff.net - Computer Jobs at all LEVELS *
*********************************************************************
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php