sql server 2008 R2中的文本挖掘

本文介绍了sql server 2008 R2中的文本挖掘的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

想要从评论表中分别提取好评和坏评论

i有一个数据库表名称tblcomments，其中有来自全球客户的1000条评论......现在我们想通过在Sql server 2008 R2商业智能工具中通过文本挖掘使用的单词来区分好的和坏的评论....

将不胜感激任何回复

谢谢

hussain

hussain。[删除] @gmail.com

SHOUTING删除，Spurious big and bold删除，Email删除 - OriginalGriff [/ edit]

want to extract good and bad comments separately from comments table

i have a database table name tblcomments which has 1000s of comments from customer all over the world... now we want to separate good and bad comments from it by words used through text mining in Sql server 2008 R2 Buisness intelligence tool....

will appreciate any response

thanks
hussain
hussain.[DELETED]@gmail.com

[edit]SHOUTING removed, Spurious big and bold removed, Email removed - OriginalGriff[/edit]

推荐答案

SELECT *
FROM tblComments
WHERE commentColumn LIKE '%bad_word_1%' or
commentColumn LIKE '%bad_word_2%' or
commentColumn LIKE '%bad_word_3%' or
commentColumn LIKE '%bad_word_4%'

这篇关于sql server 2008 R2中的文本挖掘的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！