CODEWITHSUNDEEP
phpmysqlsql
Roi
Roi

Reputation: 33

SQL - WHERE MATCH query

I have SQL query - 

SELECT id, text FROM some_table WHERE  MATCH (text, keywords) AGAINST ('".$search."' IN BOOLEAN MODE)

I'm not quite understand the difference between "IN BOOLEAN MODE" and "IN NATURAL LANGUAGE MODE".

I tried to read about it but still not get it.

Can you please explain it to me and maybe provide an example?

Upvotes: 0

Views: 207

Answers (1)

Martijn
Martijn

Reputation: 119

Just read it in the mySQL docs: Fulltext boolean mode: https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html

Fulltext natural language Mode: https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html

In summary, the boolean mode uses the + and - operators and is more 'strict'. Natural language mode returns the most 'relevant' rows according to your search.

Upvotes: 1

Related Questions