R. Alan Monroe wrote: > 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?
Try using a negative look-ahead: SELECT.*FROM(?!.*WHERE) Kent _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
