php垃圾检测,php – 使用MySQL检测垃圾邮件发送者

全文匹配

您可以看一下类似于MATCH示例here的实现：

mysql> SELECT id, body, MATCH (title,body) AGAINST

-> ('Security implications of running MySQL as root') AS score

-> FROM articles WHERE MATCH (title,body) AGAINST

-> ('Security implications of running MySQL as root');

+----+-------------------------------------+-----------------+

| id | body | score |

+----+-------------------------------------+-----------------+

| 4 | 1. Never run mysqld as root. 2. ... | 1.5219271183014 |

| 6 | When configured properly, MySQL ... | 1.3114095926285 |

+----+-------------------------------------+-----------------+

2 rows in set (0.00 sec)

所以对于你的例子,也许：

SELECT id, MATCH (content) AGAINST ('your string') AS score

FROM messages

WHERE MATCH (content) AGAINST ('your string')

AND score > 1;

请注意,要使用这些函数,您的内容列必须是FULLTEXT索引.

这个例子中得分是多少？

这是一个相关价值.它通过下面描述的过程计算：

Every correct word in the collection and in the query is weighted

according to its significance in the collection or query.

Consequently, a word that is present in many documents has a lower

weight (and may even have a zero weight), because it has lower

semantic value in this particular collection. Conversely, if the word

is rare, it receives a higher weight. The weights of the words are

combined to compute the relevance of the row.