CODEWITHSUNDEEP
mysqlsearch
Ben
Ben

Reputation: 62444

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 keywords on an SQL level?

Upvotes: 0

Views: 44

Answers (1)

Pekka
Pekka

Reputation: 449683

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.

Upvotes: 3

Related Questions