Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about CollectivesStack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack InternalYou can change the code to
string input = "select * from table where x = 5 and abc = 'p' or def = 1 order by col"; Match match = Regex.Match(input, @"(?i)select@"select.*from [a-z]+ where(.*?)(?=\s+and|$)", RegexOptions.IgnoreCase); and it will only capture the where clause up to the next and or the end of the query.
You can change the code to
string input = "select * from table where x = 5 and abc = 'p' or def = 1 order by col"; Match match = Regex.Match(input, @"(?i)select.*from [a-z]+ where(.*?)(?=\s+and|$)", RegexOptions.IgnoreCase); and it will only capture the where clause up to the next and or the end of the query.
You can change the code to
string input = "select * from table where x = 5 and abc = 'p' or def = 1 order by col"; Match match = Regex.Match(input, @"select.*from [a-z]+ where(.*?)(?=\s+and|$)", RegexOptions.IgnoreCase); and it will only capture the where clause up to the next and or the end of the query.
You can change the code to
string input = "select * from table where x = 5 and abc = 'p' or def = 1 order by col"; Match match = Regex.Match(input, @"(?i)select.*from [a-z]+ where(.*?)(?=\s+and|$)", RegexOptions.IgnoreCase); and it will only capture the where clause up to the next and or the end of the query.