MySql大数据量检索

最新推荐文章于 2024-07-19 07:15:49 发布

一包烟电脑面前做一天

最新推荐文章于 2024-07-19 07:15:49 发布

阅读量1.2k

点赞数

文章标签： mysql c# 大数据

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/MrTraum/article/details/21289129

版权

public DataTable GetNewListToDt(string where)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("SELECT id, typeid, typeid2, sortrank , flag, ismake, channel, arcrank , click, money, title, cast(shorttitle as char(37)), color, writer,");
            strSql.Append(" source, litpic, FROM_UNIXTIME(pubdate, '%Y-%m-%d') as pubdate, senddate, mid, keywords, lastpost, scores, goodpost, badpost, voteid, notpost , ");
            strSql.Append("  description, filename, dutyadmin, tackid, mtype, weight FROM dede_archives");
            if (where != string.Empty)
            {
                //strSql.Append(" where title like '%" + where + "%' or keywords like '%" + where + "%' or description like '%" + where + "%'");
                //strSql.Append(" where MATCH(keywords) AGAINST('" + where + "')");
                strSql.Append(" where FIND_IN_SET('" + where + "', keywords)");
            }
            strSql.Append(" order by sortrank");
            return DbHelperMySQL.Query(strSql.ToString());

        }