如果截取SQL语句Where前面的所有字符串
如select * from a --> select * from a
select a.id,name from a where id='aa' --> select a.id,name from a
如select * from a --> select * from a
select a.id,name from a where id='aa' --> select a.id,name from a
TestString.Substring(0,TestString.IndexOf("where"))
如果是担心没有where
你可以加判断阿!
if(TestString.IndexOf("where")<0)
return TestString;