C# 正则表达式的问题

Question

            string sqlStr = "SELECT j.hphm,NVL(tjdc.sjhm, thy.sjhm) AS sjhm1,slrq AS sjzz,j.id FROM temp ORDER BY slrq";
            string startString = ",";
            string endString = " AS sjzz";
            Regex rg = new Regex(string.Format("(?<=({0}))[.\\s\\S]*?(?=({1}))",startString,endString), RegexOptions.Multiline | RegexOptions.Singleline);
            MessageBox.Show(rg.Match(sqlStr).Value);

我想通过正则得到 sqlStr 里的字符串 slrq，但得到的结果却是 NVL(tjdc.sjhm, thy.sjhm) AS sjhm1,slrq
估计程序从sqlStr中第一个逗号开始截取，到 AS sjzz 结束。
怎样写这个正则从最接近截止符的逗号开始截取呢  例如：",slrq AS sjzz"，得到slrq。
请赐教，谢谢!
 

Answer 1

你那个碰到第一个逗号后开始匹配到后面的内容，用下面的可以

            string sqlStr = "SELECT j.hphm,NVL(tjdc.sjhm, thy.sjhm) AS sjhm1,slrq AS sjzz,j.id FROM temp ORDER BY slrq";
            string startString = ",";
            string endString = " AS sjzz";
            Regex rg = new Regex(string.Format("[^{0}]*?(?=({1}))", startString, endString), RegexOptions.Multiline | RegexOptions.Singleline);
            MessageBox.Show(rg.Match(sqlStr).Value);