110,537
社区成员
发帖
与我相关
我的任务
分享
string test = "select top 10 * from (select * from omai_user where id>10) where islock=1 order by id desc";
Regex reg = new Regex(@"(?is)(?<!\([^()]*)from\s+(\([^()]*\)|[^()])+where");
Match m = reg.Match(test);
if(m.Success)
{
richTextBox2.Text = m.Value + "\n";
}
/*-------输出-------
from (select * from omai_user where id>10) where
*/
Regex reg = new Regex(@"?!(\(((?<Open>\()|(?<-Open>\))|[^()])*(?(Open)(?!))\))*?\s{0,}where\s{0,}*?");