关于正则表达式！请帮帮我吧！！！！

[hoours]

誰能帮我写个把这个字符串
“select id,title,author from eeggs where id=1 and author='HouRS' order by ID DESC”
分解成
GROUP1＝“select id,title,author”
GROUP2＝“from eeggs”
GROUP3＝“where id=1 and author='HouRS'”
GROUP4＝“order by ID DESC”
的正则表达式！！！

先谢了！！

[hfcc999]

^(?<group1>select.+(?=from))(?<group2>from.+(?=where))(?<group3>where.+(?=order by))(?<group4>order.*)$

[robin_xin_xin]

string strReg=@"(select.*?)(from.*?)(where.*?)(order by .*?$)"
string strResource="select id,title,author from eeggs where id=1 and author='HouRS' order by ID DESC";
MatchCollection _mc;
RegexOptions _regoption=RegexOptions.Multiline;
_mc=Regex.Matches(strResource,strReg,_regoption);

Match _current=_mc[0];
str GROUP1＝_current.Group[1].Value;
str GROUP2＝_current.Group[2].Value;
str GROUP3＝_current.Group[3].Value;
str GROUP4＝_current.Group[4].Value;