[Tutor] I'm drawing a blank on a simple (?) regex

R. Alan Monroe amonroe at columbus.rr.com
Tue May 23 15:23:12 CEST 2006


I'm searching through SQL logs and want to find lines that have
WHERE-less (unbounded) queries. I can't come up with a regex to say:

SELECT.*FROM.*(the word WHERE must not exist anywhere in the remainder
of the line)

Am I forgetting something simple or would this take two passes?

Alan



More information about the Tutor mailing list