111,098
社区成员




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,}*?");