求正则替换sql语句为select count(*) from

[jimmyhoum]

求替换SQL的办法
select t0.*
(select count(*) from news where creatorid=t0.userid) pCount
from user t0
left join
(select * from xxxxx) t1
on t0.userid=t1.id
where t0.xx=xx
需要查询出该SQL的count有多少个
以前我是在这句sql外面包了句select count(*) from (上面那句sql)
但是发现MYSQL在大数据量下的嵌套查询的速度简直是无法忍受
那么我就想试着用正则表达式替换其中select.........from这一段为select count(*) from

我想从select t0.*到from user t0替换为select count(*) from
可是不知正则该如何实现我的需求，请高手帮个忙，谢谢

[wackyboy]

Regex.Replace(str,@"select t0.*[\w\W]*?from user t0","select count(*) from user");

[chenjunsheep]

楼上的好快...

[wackyboy]

Regex.Replace(str,@"select t0.*[\w\W]*?from user t0","select count(*) from user t0");

[wangdetian168]

[Quote=引用 1 楼 wackyboy 的回复:]
Regex.Replace(str,@"select t0.*[\w\W]*?from user t0","select count(*) from user");
[/Quote]
点要转义

[jimmyhoum]

问题是我并不知道是from user啊
所以正则表达式里不能出现user t0这2句