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.8k points)