方法1:
string regexString = "select(.*)from(.*)where(.*)order by(.*)";
string yourString = "select id, name from test where id = 3 and name = 'ttt' order by id desc";
Match m = Regex.Match(yourString, regexString, RegexOptions.IgnoreCase);
string t1 = m.Group[1].Value.Trim(); //id,name
string t2 = m.Group[2].Value.Trim(); //test
string t3 = m.Group[3].Value.Trim(); //id=3 and name='ttt'
string t4 = m.Group[4].Value.Trim(); //id desc
方法2:
sql语句可以用split做的;
用正则表达式的方法如下:
myRegex = New Regex("select|from|where|order by")
strVar = myRegex.Split(strTxtSql) 'strVar是一个数组