#!/usr/bin/python
# encoding: utf-8

import re

sqlscript = '''select * from payment,employee where (((1=1 and (exists(select name from employee E where E.name = payment.name)) and ((payment.name) in (select name from employee where (department='Art Designing' and employee.name=payment.name))) and (payment.name = 'jack'))) and ((1=1 and (employee.sex = 'F'))) and ((payment.name=employee.name))) order by ...
'''

patt = re.compile(r'''select(?P<fieldlist>.*?)\sfrom(?P<tblist>.*?)\swhere\s(?P<conditions>.*)order\sby(?P<orderby>.*)''', re.I|re.U|re.X|re.M)


m = patt.match(' '.join(sqlscript.splitlines()))
print m.groupdict()['conditions']

------解决方案--------------------
你相当于在帮助数据库进行执行计划的分析了，还没学到那一步，MARK下看大大解释

------解决方案--------------------

我看了一下你的where后面有括号，你可以用左右括号对等来判断，当然要排除到字符串中的括号。

------解决方案--------------------
探讨


引用:

我看了一下你的where后面有括号，你可以用左右括号对等来判断，当然要排除到字符串中的括号。

多谢提醒了
你不要看我的where有没有括号，我想问where子句的嵌套子查询是不是都必须要加括号的


------解决方案--------------------
我对Java不了解，解释一下python的正则：
patt = re.compile(r'''
  select(?P<fieldlist>.*?)\s # 非贪婪匹配select段落，到" from"为止
  from(?P<tblist>.*?)\s # 非贪婪匹配from段落，到" where "为止
  where\s(?P<conditions>.*) # 贪婪匹配where段落，
  (group\sby(?P<orderby>.*))? # "group by" 段落，可不存在
  (order\sby(?P<orderby>.*))? # "order by" 段落，可不存在
  ''', re.I|re.U|re.X|re.M)