0 votes

I tried using \Wselect\W to find select statements in SQL, but it was not finding them all.

After some experimenting, I discovered that this worked and delivered intended results: \Wselect(\W|$)

by (730 points)

1 Answer

+1 vote
 
Best answer

Unless you're using the Multi-line RegEx expression type there is no \r or \n to match. The lines are terminated at the end of the string with the EOL characters removed.

by (30.3k points)
...