Question

c#中，如何用正则表达式匹配sql语句where之前的部分？

c#中，为什么下面的正则表达式匹配出的结果是0（要求配出sql语句where之前部分）？若下面正则表达式去掉行首^符号，返回“elect * from OilTankerMeasureGrid” ，字符串行首字母s没了
new Regex(@"^[\s\S]+(?=(W|w)(H|h)(E|e)(R|r)(E|e))").Matches("select * from OilTankerMeasureGrid where Product='油品prodet' And MeasureTime between CONVERT(datetime,'2019/8/26 0:00:00',101) And CONVERT(datetime,'2019/8/29 0:00:00',101) And WaterHeight=90 ", 1)

Answer 1

foreach(Match m in new Regex(@"^(?:\s*)(.+)(?=(?i:where))").Matches("select * from OilTankerMeasureGrid where Product='油品prodet' And MeasureTime between CONVERT(datetime,'2019/8/26 0:00:00',101) And CONVERT(datetime,'2019/8/29 0:00:00',101) And WaterHeight=90 "))
{
Console.WriteLine(m.Value);
}

Answer 2

(.*?)\s*where
另外，,RegexOptions.IgnoreCase就可以忽略大小写，不需要你自己实现。