[mysql] Match Again

[fmortara]

Se faccio una query tipo:

SELECT * FROM tabella WHERE MATCH(campo, campo2) AGAINST('-valore' IN BOOLEAN MODE)

Non trova nulla, perchè?
Non dovrebbe trovare tutto quello che non ha "valore"?

[piero.mac]

again significa "di nuovo" ....

dal manuale:

-

A leading minus sign indicates that this word must not be present in any of the rows that are returned.

Note: The - operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a boolean-mode search that contains only terms preceded by - returns an empty result. It does not return “all rows except those containing any of the excluded terms.”