Reputation: 11
I tried to search for SQL
statements + some metadata in my logs using following search query:
(\d+?\s+?INSERT) | (\[\d+?\]\{\d+?\}\s+?SELECT)
but it finds only 1st part. If I put 2nd brackets in the first position - it finds it, but not the other one.
Upvotes: 0
Views: 71
Reputation: 6141
you have a space between the two clause - that will be required to match and it won't if SELECT is at the beginning of a line
Upvotes: 1