MySQL Search features such as - and +

Lets say I'm searching the field title, how would I set it up so you could use + and - on keyword开发者_如何转开发s on an SQL level?

---

Welcome to the world of Full-text searches, especially boolean searches.

Slightly modified example from the manual:

SELECT * FROM articles WHERE MATCH (title) 
AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);

you don't even need to create a FULLTEXT index for these kinds of searches but it is very recommended.